Working with the CLOB, BLOB, and BFILE data types

By now, we have gathered enough understanding on the LOB data types. We will now see the handling of LOB data in PL/SQL. For illustration purposes, we will use the EMP_LOB_DEMO table, which has been created earlier.

Initializing LOB data type columns

As we learned earlier the LOB column in the table contains only the pointer (LOB locator), while the actual data is stored in the LOB segment. The LOB segment is a different storage area in the same or different tablespace.

For initialization of a LOB data type variable or column, Oracle provides two built-in constructor methods namely, EMPTY_CLOB() and EMPTY_BLOB(). These functions are supported in SQL as well as PL/SQL. The functions assign a default ...

Get Oracle Advanced PL/SQL Developer Professional Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.