C H A P T E R  11

images

Large Objects

Organizations often deal with substantial files that need to be stored and viewed by business users. Large objects (LOBs) generally refer to a data type that is suited for storing large and unstructured data such as text, log, image, video, sound, and spatial data. Oracle supports the following types of LOBs:

  • LONG and LONG RAW
  • Character large object (CLOB)
  • National character large object (NCLOB)
  • Binary large object (BLOB)
  • Binary file (BFILE)

Prior to Oracle 8, the LONG and LONG RAW data types were your only options for storing large amounts of data in a column. You should no longer use these data types. The only ...

Get Pro Oracle Database 11g Administration now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial