This topic describes the syntax, parameters, and examples of large object (LOB) functions.
EMPTY_CLOB
Description
This function returns an empty LOB locator that can be used to initialize a LOB variable or to initialize a LOB column or attribute to EMPTY in an INSERT or UPDATE statement. EMPTY indicates that the LOB column or attribute is initialized but not populated with data.
Syntax
EMPTY_CLOB()Return value
Data of the character large object (CLOB) type is returned.
Example
SELECT EMPTY_CLOB() FROM DUAL;
empty_clob
------------
EMPTY_BLOB
Description
This function returns an empty LOB locator that can be used to initialize a LOB variable or to initialize a LOB column or attribute to EMPTY in an INSERT or UPDATE statement. EMPTY indicates that the LOB column or attribute is initialized but not populated with data.
Syntax
EMPTY_BLOB()Return value
Data of the binary large object (BLOB) type is returned.
Example
SELECT EMPTY_BLOB() FROM DUAL;
empty_blob
------------