The following table lists the available lob/clob functions, and a description of their purpose.
Function | Description |
---|---|
EMPTY_BLOB | Returns an empty BLOB (Binary Large Object), that is, one that contains 0 bytes. |
EMPTY_CLOB | Returns an empty CLOB (Character Large Object), that is, one that contains 0 bytes. |
See the Teradata Database SQL Functions, Operators, Expressions, and Predicates document, B035-1145, for a detailed overview of these lob/clob functions.