Using BLOB, CLOB, and NCLOB Data Types

This section uses CLOB values to demonstrate how to access and change LOB data types. The approaches to working with the CLOB data types map to BLOB and NCLOB data types because all three types work the same way. This section is divided into two parts:

  • How to read CLOB columns

  • How to update CLOB columns

Adding CLOB and BFILE columns to the PRESIDENT table extends the example from Chapters 13 and 14. You add the LOB columns by using the following statements:

-- This is found in alter_world_leaders.sql on the enclosed CD.

-- Add a CLOB column to the PRESIDENT table.
ALTER TABLE PRESIDENT ADD (biography CLOB);

-- Add a BFILE column to the PRESIDENT table.
ALTER TABLE PRESIDENT ADD (photograph BFILE);

After ...

Get Oracle Database 10g Express Edition PHP Web Programming now with O’Reilly online learning.

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