plsql

Question

types of variable in plsql and what are large objects?

Kirtan Patel · Answer

Large Object (LOB) : Large objects are data type in PL/SQL . When you want to store Huge data in database like large binary files etc you can use this data types bfile Maximum file size of 4GB. Maximum file size of 2 32 -1 bytes. Maximum file size of 2 64 -1 bytes. File locators that point to a binary file on the server file system (outside the database). blob Store up to 4GB of binary data. Store up to (4 gigabytes -1) * (the value of the CHUNK parameter of LOB storage). Store up to (4 gigabytes -1) * (the value of the CHUNK parameter of LOB storage). Stores unstructured binary large objects. clob Store up to 4GB of character data. Store up to (4 gigabytes -1) * (the value of the CHUNK parameter of LOB storage) of character data. Store up to (4 gigabytes -1) * (the value of the CHUNK parameter of LOB storage) of character data. Stores single-byte and multi-byte character data. nclob Store up to 4GB of character text data. Store up to (4 gigabytes -1) * (the value of the CHUNK parameter of LOB storage) of character text data. Store up to (4 gigabytes -1) * (the value of the CHUNK parameter of LOB storage) of character text data. Stores Unicode data.

plsql

Answers (1)