EMPTY_CLOB function : EMPTY_CLOB « Large Objects « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Large Objects
3. EMPTY_CLOB

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>