O'Reilly logo

Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts by John Adolph Palinski

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

Processing Objects

In Chapter 2, you saw that the Oracle9i database was able to contain objects. You can create an object type and use this same object type in many different tables. You can also create varrays, nested tables, and object tables. PL/SQL is normally used to process these database objects because a code block has the ability to employ types that are identical to the object types used in the various Oracle9i objects. These types can be used to accept the database object types and to process the individual components.

If you remember, objects are actually one record. The record does not contain columns as in a table. It actually consists of a set of segments that are known only when the object is processed using the object-type template. ...

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