[zapov]

We 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]

Right, you're right, I overlooked CREATE TABLE OF.