C H A P T E R  12

Images

Using LOBs and BFILEs

In this chapter, you’ll learn what large objects (LOBs) are and how they’re stored in Oracle. You’ll also see how to retrieve and manipulate LOBs, and you’ll explore some benchmarks comparing various alternatives when manipulating them through the JDBC API.

What Are LOBs?

Large objects (LOBs) are data types designed to hold large amounts of data. In 9i, a LOB can store up to 4GB of data. In 10g, a LOB can store up to a maximum range of 8TB to 128TB depending on how your database is configured. LOBs are typically used to store unstructured text data, such as text files, and binary data, such as GIFs, multimedia ...

Get Expert Oracle JDBC Programming 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.