|Oracle® Database Application Developer's Guide - Large Objects
10g Release 1 (10.1)
Part Number B10796-01
A Large Object datatype that is a binary file residing in the file system, outside of the database datafiles and tablespace. Note that the BFILE datatype is also referred to as an external LOB in some documentation.
A Large Object datatype that has content consisting of binary data and is typically used to hold unstructured data. The BLOB datatype is included in the category Persistent LOBs because it resides in the database.
Pronounced "bee-lob." See Binary Large Object.
The LOB datatype that has content consisting of character data in the database character set. A CLOB may be indexed and searched by the interMedia Text search engine.
Pronounced "see-lob." See Character Large Object.
A Large Object datatype that is stored outside of the database tablespace. The BFILE datatype is the only external LOB datatype. See also BFILE.
A large object (LOB) that is stored in the database in a BLOB/CLOB/NCLOB column.
To examine attributes or value of an object.
Large Objects include the following SQL datatypes: BLOB, CLOB, NCLOB, and BFILE. These datatypes are designed for storing data that is large in size. See also BFILE, Binary Large Object, Character Large Object, and National Character Large Object.
See Large Objects.
A large object datatype that is a field of an abstract datatype. For example a
CLOB field of an
The actual data stored by the Large Object. For example, if a BLOB stores a picture, then the value of the BLOB is the data that makes up the image.
The LOB datatype that has content consisting of character data in the database national character set. A CLOB may be indexed and searched by the interMedia Text search engine.
Pronounced "en-see-lob." See national character Large Object.
NCLOB that is stored in the database. A persistent LOB instance can be selected out of a table and used within the scope of your application. The ACID properties of the instance are maintained just like any other column type. Persistent LOBs are sometimes also referred to as internal persistent LOBs or just, internal LOBs.
A persistent LOB can exist as a field of an abstract datatype as well as an instance in a LOB-type column. For example a
CLOB attribute of an instance of type
See also temporary LOB and external LOB.
A database storage unit that groups related logical structures together.
A BLOB, CLOB, or NCLOB that is accessible and persists only within, the application scope in which it is declared. A temporary LOB does not exist in database tables.