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. ...
Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.