1
Reply

What are the Large object types supported by Oracle?

Sapna Malik

Sapna Malik

15y
4.6k
0
Reply

    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.