3 ms·
It should be noted that Oracle's object types are a feature of PL/SQL, their imperative programming language. PostgreSQL's concept of object-relational databas
by jacques_chester 13y ago
It should be noted that Oracle's object types are a feature of PL/SQL, their imperative programming language.
PostgreSQL's concept of object-relational databases is baked into the SQL. Into the logical model of the data itself.
Put another way: Oracle doesn't have table inheritance.
- zapov 13y agoWe are using Oracle object types in plain SQL, so no, they are not PL/SQL exclusive. But yeah, you can do a lot less with them outside of PL/SQL.
- jacques_chester 13y agoRight, you're right, I overlooked CREATE TABLE OF.