O'Reilly logo

Pro Oracle Database 11g Administration by Darl Kuhn

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required