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.