<<Previous Next>>
Oracle - What are LOB
datatypes? - Feb 23, 2010 at 11:00 PM by Rajmeet
Ghai
What are LOB datatypes?
LOB is large object byte used to store large amount of data. The
following types come under LOB data types:
CLOB and NCLOB can
both be used to store 4 GB of data in the database.
BLOB: Binary LOB is used to store binary
data.
CLOB (Character Large Object) is used
specifically to store character set data whole NCLOB (National Large
Object) is specifically used to store Unicode national character set
data.
Oracle - What
are LOB datatypes? - April 10, 2009
at 11:00 AM
What are LOB datatypes?
The LOB datatypes such as BLOB, CLOB, NCLOB
and BFile can store large blocks of unstructured data such as
graphics, image, video clips etc. They provide random and piece-wise
access to the data.
Also read
Explain the differences between char and varchar2 data types,
Explain BLOB, CLOB, NCLOB and BFILE, Explain ROWID in oracle, What
is a LOB data type?...........
What is large object in oracle? Explain its purposes, Explain
types of large objects in oracle, i.e. BLOB, LLOB,NCLOB and
BFILE............
Both CLOB and NCLOB are used to store huge character data in the
database, CLOBs store single-byte character set data............
The BFILE datatype is used to store unstructured binary data
outside the database. The column of BFILE type stores file locator
that points the OS file which actually stores data...........
Varrays, variable length array is quite similar to array of C++
or Java. It has fixed upper-bound size that has to be specified
while it is declared...........
|
