SQL>
SQL>
SQL> desc user_varrays;
Name Null? Type
-----------------------------------------
PARENT_TABLE_NAME VARCHAR2(30) Name of the table that contains the varray.
PARENT_TABLE_COLUMN VARCHAR2(4000) Name of the column in the parent table containing the varray.
TYPE_OWNER VARCHAR2(30) User who owns the varray type.
TYPE_NAME VARCHAR2(30) Name of the varray type.
LOB_NAME VARCHAR2(30) Name of the large object (LOB) if the varray is stored in a LOB. You'll learn about LOBs in the next chapter.
STORAGE_SPEC VARCHAR2(30) Storage specification for the varray.
RETURN_TYPE VARCHAR2(20) Return type of the column.
ELEMENT_SUBSTITUTABLE VARCHAR2(25)
SQL>
SQL> CREATE Or Replace TYPE addressVarray AS VARRAY(2) OF VARCHAR2(50);
2 /
Type created.
SQL> DESCRIBE addressVarray;
addressVarray VARRAY(2) OF VARCHAR2(50)
SQL>
SQL> --SELECT * FROM user_varrays;
SQL>
SQL>
SQL>
30.109.user_varrays |
| 30.109.1. | Get information on your varrays from the user_varrays view |