Chapter 6. Implementing PL/SQL Objects

PL/SQL objects have become powerful in Oracle 9i. They enable you to develop object types as replacements to record types, build object views, and use transient objects to build a façade to hide the complexity of subsystems.

While PL/SQL object types were introduced in Oracle 8, you'll find they've grown up with the release of Oracle 9i. The Oracle 9i release presents a new face to leveraging object-oriented (OO) development practices within PL/SQL. In this chapter, you'll learn how to define and use PL/SQL objects in the database for a number of purposes. You'll review the basics, definitions, constructions, assignments, and record-type substitutions. After covering the basics, you'll explore limitations ...

Get Expert Oracle PL/SQL 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.