Oracle PL/SQL Tutorial/System Tables Data Dictionary/all varrays
Версия от 16:45, 26 мая 2010; (обсуждение)
Get information on all the tables you have access to using all_varrays.
<source lang="sql">
SQL> SQL> desc all_varrays;
Name Null? Type OWNER VARCHAR2(30) PARENT_TABLE_NAME VARCHAR2(30) PARENT_TABLE_COLUMN VARCHAR2(4000) TYPE_OWNER VARCHAR2(30) TYPE_NAME VARCHAR2(30) LOB_NAME VARCHAR2(30) STORAGE_SPEC VARCHAR2(30) RETURN_TYPE VARCHAR2(20) ELEMENT_SUBSTITUTABLE VARCHAR2(25)
SQL> SQL> --select * from all_varrays;</source>