EMPTY_CLOB
Purpose
Returns an empty CLOB (Character Large Object), that is, one that contains 0 bytes.
Syntax
where:
Syntax element … |
Specifies … |
TD_SYSFNLIB |
the name of the database where the function is located. |
ANSI Compliance
This is a Teradata extension to the ANSI SQL:2011 standard.
Invocation
EMPTY_CLOB is an embedded services system function. For information on activating and invoking embedded services functions, see “Embedded Services System Functions” on page 24.
Argument Types
EMPTY_CLOB takes zero input arguments.
Result Type
EMPTY_CLOB is a scalar function whose return value data type is CLOB AS LOCATOR in the LATIN character set.
Example
The following query:
UPDATE student SET essay = EMPTY_CLOB();
updates the essay column with an empty CLOB.