EMPTY_BLOB() function : EMPTY_BLOB « Large Objects « Oracle PL/SQL Tutorial

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

SQL>
SQL> CREATE TABLE myBlob
  2  (id NUMBER PRIMARY KEY,
  3   blob_data BLOB);

Table created.

SQL>
SQL>
SQL> UPDATE myBlob
  2  SET blob_data =EMPTY_BLOB()
  3  WHERE id =1;

0 rows updated.

SQL>
SQL> drop table myBlob;

Table dropped.

SQL>
SQL>