LOB types in PLsql

Published on August 18 2015 by LakshmiSaahul,Dhana Royal

LOB data types used to store large objects such as image, video, graphics, text or audio. Maximum size is up to 4 Gigabytes. Following are the LOB data types in PL/SQL:

BFILE
BFILE data type is used to store large binary objects into Operating System file. BFILE stores full file locator's path which are points to a stored binary object with in server. BFILE data type is read only, you can't modify them. Size: up to 4GB (232 - 1 bytes)
Directory name: 30 character
File name: 255 characters
BLOB
BLOB data type is same as BFILE data type used to store unstructured binary object into Operating System file. BLOB type fully supported transactions are recoverable and replicated. Size: 8 TB to 128 TB
(4GB - 1) * DB_BLOCK_SIZE
CLOB
CLOB data type is used to store large blocks of character data into Database. Store single byte and multi byte character data. CLOB type is fully supported transactions, also that are recoverable and replicated. Size: 8 TB to 128 TB
(4GB - 1) * DB_BLOCK_SIZE
NCLOB
NCLOB data type to store large blocks of NCHAR data into Database. Store single byte and multi byte character data. NCLOB type fully supported transactions are recoverable and replicated. NCLOB data type is used to store large blocks of NCHAR data into Database. Store single byte and multi byte character data. NCLOB type fully supported transactions, also that are recoverable and replicate
Size: 8 TB to 128 TB
(4GB - 1) * DB_BLOCK_SI

Advertising