June 2005
Intermediate to advanced
722 pages
18h 9m
English
![]()
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.
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 ...
Read now
Unlock full access