SQL - LOB (large object)

Data System Architecture


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 actual data: ie:

External files are managed similarly.

SQL Type

The LOB data type creates a stream.

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 - Character large object (CLOB)

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...
Data System Architecture
Sql - Binary large object (BLOB) data type

Binary large object (BLOB) is a SQL data type suited to store a blob file (ie binary data). In a database, a blob is implemented via pointer to the local file system (known as a lob (large object) ...

Share this page:
Follow us:
Task Runner