O'Reilly logo

Oracle PL/SQL For Dummies by Paul Dorsey, Michael Rosenblum

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

Chapter 11

Advanced Datatypes

In This Chapter

bullet Working with large objects (LOBs)

bullet Enforcing standards with user-defined subtypes

bullet Defining datatypes

bullet Creating collections

bullet Collecting data with bulk operations

To be able to handle many of the complex programming situations that can arise in building database systems, Oracle includes some advanced datatypes and ways to handle large objects, user-defined types and subtypes, and collections.

It is important to understand how to use these datatypes correctly and efficiently in your code, and in the sections in this chapter, we show you how.

Handling Large Objects in the Database

Less-experienced database professionals might think that the three major datatypes (DATE, NUMBER, VARCHAR2) are enough to build most systems. However, this is rarely the case. In modern systems, you might want to store pictures, movies, documents, and sounds. The basic Oracle character datatype (VARCHAR2) can hold only 4,000 characters (about the size of a page of ...

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