Large Objects (LOBs) are designed to hold large amounts of data. They are suitable for semi-structured data (like XML documents) and unstructured data (like MP3 files). There are two basic types: external LOBs, which are stored outside the database, and internal LOBs that are stored inside database tablespaces. Each LOB has a locator and a value. The LOB locator is a reference to where the LOB value is physically stored. LOB columns in the database can’t be manipulated with standard DML statements, you need to use an Oracle supplied package called DBMS_LOB.
Viewing entries tagged