I am new to using LOB data types. Could anyone double confirm if my
understanding of the basic concept is correct.
- When I declare a variable of CLOB type and init it with empty_clob(),
only a locator is declare. There is no physical storage area allocated.
- But when I insert that variable into a table's column, some physical
storage in the disk is allocated **implicitly**.
- Alternatively, after declaring a variable of CLOB type, I can refer to
some physical disk storage area without having to insert the locator into a
table by using DBMS_LOB.CREATETEMPORARY() which will create a temporary
storage area.
Am I correct?
Received on Tue Jun 28 2005 - 21:49:36 CDT