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

Oracle Object-Oriented Features

The Oracle database changed from a relational database to an object-relational database with the Oracle8i release. I believe that industry primarily uses Oracle in the relational paradigm and will continue to do so for a long time. However, you may encounter some databases that use Oracle’s object technology, so it is worth your time to review the basics.

Object technology can potentially eliminate database complexity and increase performance. In the previous chapter, you saw that databases could be very complex. The attributes are contained in multiple tables. It can be extremely difficult to write SQL that retrieves the desired attributes. Even experienced data administrators have difficulty producing the information. ...

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