Oracle PL/SQL Tutorial/Large Objects/EMPTY CLOB

EMPTY_CLOB function

SQL>
SQL> CREATE TABLE myClob
  2  (id NUMBER PRIMARY KEY,
  3   clob_data CLOB);
Table created.
SQL>
SQL> UPDATE myClob
  2  SET clob_data =EMPTY_CLOB()
  3  WHERE id =101;
0 rows updated.
SQL>
SQL>
SQL>
SQL> drop table myClob;
Table dropped.
SQL>