Explain BLOB, CLOB, NCLOB and BFILE
Explain BLOB, CLOB, NCLOB and BFILE.These are the built in large object data types.
- BLOB, CLOB, NCLOB are stored internally where as BFILE is stored externally. - The BLOB data type stores binary large objects. - The CBLOB data type stores character large objects. - The NCBLOB data type stores character large objects in multibyte national character set. - The BFILE data type enables access to binary file LOBs that are stored in file systems outside the Oracle database.
All these data types have a capacity of 4GB.
|
Explain ROWID in oracleEach table in oracle has a pseudocolumn called ROWID. Oracle uses ROWID to store address of each rows of the table......
What is a LOB data type?The LOB datatypes includes BLOB, CLOB, NCLOB and BFILE that can store large blocks of unstructured data such as graphic images......
Explain DCL commandDCL: Data Control Language DCL are used to configure and control database objects....