Oracle again branded itself as ORDBMS with the release of 8.0, which was the version when TYPE arrived. However, this was not a very complete implementation of the object. There was no inheritance in the first release, and until 9iR2 — three major releases later — to get user-defined constructors. Even now, when 11g out, encapsulation is not fully supported: TYPEs cannot have private variables or methods.
It turned out that very few existing Oracle clients took care of objects, and very few OO programmers were interested in databases. In addition, a new next “Big thing” has appeared: the Internet. Therefore, when version 8.1 was released, Oracle returned to simple RDBMS, albeit with Internet support. Consequently, tag 8 i (i.e., had Java stored procedures).
For those of us who have grown up in SQL, implementing an object is a bit awkward and has little to do with storage. However, TYPEs were an important addition to the PL / SQL arsenal, especially collections and bulk processing. Inheritance and polymorphism may be useful in some niche scenarios. I introduced this topic to the annual UKOUG conference a few years ago. Find out more .
Edit
Oracle continues to include all of its ORDBMS features in every database release. They are quite extensive (except for the lack of private variables and methods). I do not know how it compares with PostgreSQL. The Oracle OR features are described in the Oracle online documentation, which you can read here here .