Oracle SQL LOB--Large Objects

we can store higher volumes of data with max size 4 GB.

LOB are three types.  

 

CLOB--CHAR LOB --used to store character data

BLOB-- BINARY LOB -- Used to store binary data

NCLOB --Fixed length multi char large objects

           --Used to store both binary and char data

 

 BFILE (BINARY FILE )

1.    It is a pointer to the external file from database.

2.    We can read data from external file and we can write data on external file, through BFILE pointer.