O'Reilly logo

Expert Oracle PL/SQL by Michael McLaughlin, Ron Hardman

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 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 ...

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