Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle EMPTY_CLOB Function      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: EMPTY_CLOB

Definition:
Similar to EMPTY_BLOB, the Oracle EMPTY_CLOB function is used for the initialization of CLOB columns in the table. As a reminder, note that empty CLOB does not mean a LOB of zero length.

Example Usage:

During TABLE definitions, EMPTY_CLOB can be used to set default value of a column:

CREATE TABLE XML_TAB
(DOC_ID NUMBER,
XMLDOC CLOB DEFAULT EMPTY_CLOB);

Table created.


The UPDATE statement below would set the XMLDOC column of the table XML_TAB to empty CLOB.

UPDATE XML_TAB
SET XMLDOC = EMPTY_CLOB();

1 row updated.


Related Links:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 135 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?