Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-03
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


ALL_NESTED_TABLES describes the nested tables in tables accessible to the current user.

Related Views

Column Datatype NULL Description
OWNER VARCHAR2(30)   Owner of the nested table
TABLE_NAME VARCHAR2(30)   Name of the nested table
TABLE_TYPE_OWNER VARCHAR2(30)   Owner of the type of which the nested table was created
TABLE_TYPE_NAME VARCHAR2(30)   Name of the type of the nested table
PARENT_TABLE_NAME VARCHAR2(30)   Name of the parent table containing the nested table
PARENT_TABLE_COLUMN VARCHAR2(4000)   Column name of the parent table that corresponds to the nested table
STORAGE_SPEC VARCHAR2(30)   Indicates whether storage for the nested table is USER_SPECIFIED or DEFAULT
RETURN_TYPE VARCHAR2(20)   Return type of the varray column (LOCATOR) or (VALUE)
ELEMENT_SUBSTITUTABLE VARCHAR2(25)   Indicates whether the nested table element is substitutable (Y) or not (N)