SQL - Character large object (CLOB)

Data System Architecture

About

A Character large object (CLOB) is a SQL data type used to store a large amount of character data.

It's a specialized variant of large object (LOB) where data is stored in a file on the local file system with a text mime. The database would then decode the binary into a text and send it to you.

Analytics

You would not use any clob column in any group by or window/aggregation function to perform any analtyics.

You would mostly retrieve the content and process it with a third application.





Discover More
Card Puncher Data Processing
Oracle - LOB Datatype

LOB in Oracle In Oracle, a LOB is simply a pointer that points to an index that is stored in a LOBINDEX segment. The index points to the chunks that make up the LOB that are stored in LOBSEGMENT segment....
Data System Architecture
SQL - Data Type

The Data Type of a column in SQL. They are defined in the ANSI/ISO SQL standard but may vary from sql engine (database) to another. The below table shows you the history of the data type in the ANSI...
Data System Architecture
SQL - LOB (large object)

The term large object (LOB) refers to a data item that is too large to be stored directly in a database table. Instead, a pointer is stored in the database table, which points to the location of the...
Data System Architecture
SQL - String Data Type

This page is the SQL data type that can be used in SQL to represent a string. The following data type are using the locale character set to encode the string: CHAR VARCHAR CLOB The following...



Share this page:
Follow us:
Task Runner