Understanding the LOB data types
As we came across the four LOB data types in Oracle, LOB structure can be split into its "What" and "Where" components. While LOB value answers to the "What' query, the LOB locator corresponds to the "Where" part. Together, they both make a complete structure of an LOB. Let us understand the LOB components.
LOB value and LOB locators
The LOB value is the actual large file to be loaded in the database. The LOB locator points to the location of this file on the system. It can be thought of as a pointer which references the system location of a file. A LOB locator is always stored inline with the table row irrespective of where the LOB value is stored. During insertion of the LOB data, the LOB column necessarily has ...
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.
