Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_NESTED_TABLES

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)
Whether storage for the nested table is USER-SPECIFIED or DEFAULT
RETURN_TYPE VARCHAR2(20)
Return type of the varray column (LOCATOR | VALUE)
ELEMENT_SUBSTITUTABLE VARCHAR2(25)   Indicates whether the nested table element is substitutable (Y) or not (N)