Show TOC

Object documentationLOB Column

 

The data type (data_type) CLOB or BLOB is used to define an alphanumeric column of any length (not for temporary tables). The required data type is specified in the column definition, with a code attribute, if required.

  • CLOB [ASCII]: A maximum of 2 GB of characters can be written in a LOB column.

  • CLOB UNICODE: A maximum of 2 GB bytes can be written in a LOB column.

  • BLOB: A maximum of 2 GB of characters can be written in a LOB column.

 

Only a few functions can be applied to a LOB column: DECODE, LENGTH and SUBSTR.

LOB columns cannot be compared to one another. The contents of LOB columns cannot be compared to character strings or other data types.

LOB columns can only contain NOT NULL or a DEFAULT specification as a column attribute.

More Information

LOB columns can be used in the following SQL statements and syntax elements:

Column Definition (column_definition)

Glossary, LOB