O'Reilly logo

Oracle Advanced PL/SQL Developer Professional Guide by Saurabh Gupta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Managing LOB data types

The LOB data management includes its interaction with the loading interface, data manipulation strategies, and selection of the LOB data. The section makes certain recommendations to manage internal LOBs, BFILEs, and temporary LOBs.

Managing internal LOBs

An internal LOB data type that is, a CLOB or BLOB data type column can be interacted through supported interfaces such as DBMS_LOB, JDBC, or OLE object structure. In PL/SQL, LOB data is majorly managed through the DBMS_LOB package which provides a wide variety of subprograms to populate the LOB data, manipulate it, and extract relevant information such as length, size, and so on.

Few of the recommendations to manage the internal LOB are as follows:

  • The LOB column can be ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required