ORACLE EMPTY_BLOB(), EMPTY_CLOB()

오라클 EMPTY_BLOB()

오라클 EMPTY_CLOB()

 

EMPTY_BLOB and EMPTY_CLOB return an empty LOB locator that can be used to initialize a LOB variable or, in an INSERT or UPDATE statement, to initialize a LOB column or attribute to EMPTY. EMPTY means that the LOB is initialized, but not populated with data.

 

An empty LOB is not the same as null LOB, and an empty CLOB is not the same as a LOB containing a string of 0 length.

 

 

UPDATE table_name set column_name = EMPTY_CLOB();