Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Get information on your varrays from the user_varrays view

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>