EMPTY_BLOB
Purpose
Returns an empty BLOB (Binary 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_BLOB 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_BLOB takes zero input arguments.
Result Type
EMPTY_BLOB is a scalar function whose return value data type is BLOB AS LOCATOR.
Example
The following query:
UPDATE employee SET picture = EMPTY_BLOB();
updates the picture column with an empty BLOB.