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

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.