EMPTY_CLOB

Oracle

Example

DECLARE
   empty_clob_var CLOB;
BEGIN
   empty_clob_var := EMPTY_CLOB();

   DBMS_OUTPUT.PUT_LINE('CLOB length is: ' || DBMS_LOB.GETLENGTH(empty_clob_var));
END;
/

Output

CLOB length is: 0

Explanation

The EMPTY_CLOB() function creates a temporary CLOB with a length of 0. The DBMS_LOB.GETLENGTH function then retrieves the length of this CLOB, which, as outputted, returns 0.