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.
Loading
