Oracle PL/SQL Tutorial/System Tables Data Dictionary/user varrays

Материал из SQL эксперт
Перейти к: навигация, поиск

30. Get information on your varrays from the user_varrays view

   <source lang="sql">

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)</source>
Источник — «http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/user_varrays&oldid=3862»