Table types appear within the Types node in the Object Navigator. A table type node represents a type created by the SQL statement, CREATE TYPE AS TABLE. The table type is displayed in the Object Navigator as:
table-type-name (TABLE OF table-subtype-name)
The table type node is not expandable if the subtype is a Built-in type. If the subtype is an object type or REF object, the attributes of the object appear as subnodes.
Oracle Object Support in the Object Navigator
The following SQL statements create the object type emp_typ and the table type emp_tbl.
CREATE TYPE emp_typ AS OBJECT
(ename VARCHAR2(30), esalary NUMBER(5,2),
MEMBER PROCEDURE raise(amount NUMBER),
MEMBER FUNCTION get_salary RETURN NUMBER,
MAP MEMBER FUNCTION compare RETURN NUMBER);
CREATE TYPE emp_tbl AS TABLE OF emp_typ;
The subtree for emp_tbl is: