A script-enabled browser is required for this page to function properly.

Varying Array Type Nodes

Varying array types appear within the Types node in the Object Navigator. A varying array type node represents a type created by the SQL statement CREATE TYPE AS VARYING ARRAY. The varying array type is displayed in the Object Navigator as:

varying-array-type-name (VARRAY (size) varying-array-subtype-name)

The varying array 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.

Varying Array Type Node Example

Oracle Object Support in the Object Navigator

Oracle objects examples

The following SQL statements create the object type emp_typ and the varying array type emp_ary.

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_ary AS VARRAY(7) OF emp_typ;

The subtree for emp_ary is:

diagram showing subtree for emp_ary


Oracle Object Support in the Object Navigator