Murach's Oracle SQL and PL/SQL
How to work with large objects

This chapter shows you how to use Oracle's large object (LOB) data types, which are designed to store large amounts of character or binary data, including image, sound, and video files.
Chapter 18 How to work with large objects
An introduction to large objects 562
The LOB types 562
APIs for working with LOBs 562
How to use SQL to work with large objects 564
How to work with CLOBs 564
How to work with NCLOBs 564
How to work with BLOBs 566
How to work with BFILEs 568
How to specify LOB storage options 570
How to migrate to the new LOB types 572
How to use Java to work with large objects 574
The main method for the sample application 574
How to write an image to a table 576
How to read an image from a table 580
A utility class for working with databases 582
How to use PL/SQL to work with large objects 586
The methods of the DBMS_LOB package 586
An example that uses the DBMS_LOB package 588


© Copyright 1998-2009 Mike Murach & Associates, Inc.  All rights reserved.

Murach's Oracle SQL and PL/SQL

Learn more about this book

View the table of contents

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.