SQL - LOB (large object)
Table of Contents
About
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:
- a file in the local file system
- or a location into a file in the local file system
External files are managed similarly.
SQL Type
- Sql - Binary large object (BLOB) data type for binary data
- SQL - Character large object (CLOB) for character data
The LOB data type creates a stream.