Chapter 6. Working with Large Objects

The challenge to manage information in a database has never been an iced cake. Besides the fundamental support to data integrity, security, and optimal storage mechanisms, the support to varied natures of data was equally challenging. With the growing demands of application development, the nature of large and unstructured data has been transformed from character based to binary based information.

Prior to the introduction of LOB data types in Oracle 8 Release, the LONG and LONG RAW data types used to serve as the storage type for large data. Numerous limitations associated with LONG data types and the need of a stable storage mechanism for unstructured data led to the evolution of LOB data types and set the ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.