What are the Large object types supported by Oracle?

Questions by Beena   answers by Beena

Showing Answers 1 - 6 of 6 Answers

Yadav Anand V

  • Oct 27th, 2005
 

blob,clob,blob,nlob these ususaly support data up to 4GB

  Was this answer useful?  Yes

soji

  • Jan 20th, 2006
 

Oracle provides six data types for storing LOBs:

? CLOB and LONG for large fixed-width character data

? NCLOB for large fixed-width national character set data

? BLOB and LONG RAW for storing unstructured data

? BFILE for storing unstructured data in operating system files

LONG and LONG RAW data types were previously used for unstructured data, such as binary images, documents, or geographical information, and are primarily provided for backward compatibility. These data types are superseded by the LOB data types. LOB at types are distinct from LONG and LONG RAW, and they are not interchangeable. LOBs will not support the LONG application programming interface (API), and vice versa.

  Was this answer useful?  Yes

manish hoiyani

  • Sep 14th, 2006
 

clob, blob, used to unstructured data and binary data respectively.

  Was this answer useful?  Yes

raghu2110

  • May 20th, 2008
 

Blob datatype is used for storing large Binary data Like Photos,signatures etc 
Clob datatype is used for stoeing large character data upto 4GB like resume and other docs

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions