Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
Functions, 27 of 121
EMPTY_BLOB
and EMPTY_CLOB
returns 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.
You cannot use the locator returned from this function as a parameter to the DBMS_LOB package or the OCI.
INSERT INTO lob_tab1 VALUES (EMPTY_BLOB()); UPDATE lob_tab1
SET clob_col = EMPTY_BLOB();
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|