Define CLOB and NCLOB datatypes

<<Previous  Next>>

Define CLOB and NCLOB datatypes.

CLOB and NCLOB can both be used to store 4 GB of data in the database.
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 - Define CLOB and NCLOB datatypes - Feb 07, 2010 at 14:20 PM by Shuchi Gauri

Define CLOB and NCLOB datatypes.

CLOB: Character large object. It is 4GB in length.
NCLOB: National Character large object. It is CLOB datatype for multiple character sets , upto 4GB in length.

Oracle - Define CLOB and NCLOB datatypes - June 27, 2009 at 11:00 AM

Define CLOB and NCLOB datatypes.  

Both CLOB and NCLOB are used to store huge character data in the database.
CLOBs store single-byte character set data.
NCLOBs store fixes-length multi-byte character set data.
Both these datatypes participate fully in transactions.

Also read

Oracle data types

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?..........

Oracle large objects

What is large object in oracle? Explain its purposes, Explain types of large objects in oracle, i.e. BLOB, LLOB,NCLOB and BFILE............

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.............

<<Previous  Next>>

Write your comment - Share Knowledge and Experience