Sapna Malik
What are the Large object types supported by Oracle?
By Sapna Malik in Databases & DBA on Sep 01 2009
  • Partap Tanwar
    Sep, 2009 7

    Oracle provides six data types for storing LOBs:
    1.CLOB and LONG for large fixed-width character data.
    2.NCLOB for large fixed-width national character set data.
    3.BLOB and LONG RAW for storing unstructured data.
    4.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.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS