-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Advanced Oracle PL/SQL Developer's Guide (Second Edition)
By :

Oracle provides four data types dedicated for declaring large objects, namely: BLOB
, CLOB
, NCLOB
, and BFILE
.
There are three types of internal LOB
data types, namely:
BLOB
: The Binary Large Object data type is used to store large binary files that cannot be logically broken down to data bits such as PDFs, images, audios or videos, and so on.
CLOB
: The Character
Large Object data type stores the single-byte character data in the database character set format. It supports fixed-width character formats.
NCLOB
: The
CLOB
data type that can store national character set data and support varying width format character sets.
Starting from Oracle 10g, Oracle can cast the CLOB
data to the VARCHAR2
data implicitly.
A BFILE
is an SQL data type for the external LOB
data type. It is the read-only data type that stores a locator for a binary file whose physical location is outside the Oracle Database. Deleting a BFILE
column value (or setting it to NULL
) will drop...
Change the font size
Change margin width
Change background colour