O'Reilly logo

Java™ Oracle® Database Development by David J. Gallardo

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

Large Objects—BLOBs and CLOBs

The SQL types we've used so far in this and previous chapters—NUMBER, VARCHAR2, and DATE—correspond more or less to basic Java types, such as int, long double, Date, and String. To allow maximum flexibility, SQL also supports untyped objects, which—unlike the other SQL types—are virtually unlimited (up to 4 gigabytes) in size. These are called large objects (LOBs) and come in two varieties, character large objects (CLOBs) and binary large objects (BLOBs). The latter are especially well named because they are, in effect, just blobs to the database—undifferentiated stuff with no meaning, as far as the database is concerned.

One way to think of the difference between BLOBs and CLOBs is by analogy to the difference between ...

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