Discussion Board

BLOB, CLOB, NCLOB and BFILE Yes, BLOB, CLOB, NCLOB and BFILE are all LOB data types. The built-in LOB data types BLOB, CLOB and NCLOB (stored internally), and BFILE (stored externally), can store large and unstructured data such as text, images and spatial data up to 4 gigabytes in size. BLOB stores binary large objects. BLOB can store up to 4 gigabytes of binary data. CLOB stores character large objects. CLOB can store up to 4 gigabytes of character data. NCLOB stores character large objects in multibyte national character set. NCLOB can store up to 4 gigabytes of character data. BFILE enables access to binary file LOBs that are stored in file systems outside the Oracle database. A BFILE column stores a locator, which serves as a pointer to a binary file on the server's file system. The maximum file size supported is 4 gigabytes. Prajakta Pandit 02-9-2017 06:15 AM

Write your comments

*

* Email must be in the form someone@domain.com

*

*