Large-Object Data Types

Large-object data types can store extremely large column values, such as images and documents, independently of the column.


Large-Object Data Type

|--+-+-TEXT-+--+-------------------+-+--------------------------|
   | '-BYTE-'  '-IN--+-TABLE-----+-' |   
   |                 '-blobspace-'   |   
   '-+-BLOB-+------------------------'   
     '-CLOB-'

Element	Description	Restrictions	Syntax
blobspace	Name of an existing blobspace	Must exist	Identifier

The large object data types can be classified in two categories:

Simple large objects: TEXT and BYTE
Smart large objects: CLOB and BLOB