Home Oracle Commands Oracle Data Dictionary
v$ Performance views

ALL_NESTED_TABLES

Description of nested tables in tables accessible to the user

Columns
   ___________________________
 
   RETURN_TYPE
   STORAGE_SPEC
   PARENT_TABLE_COLUMN
      Column name of the parent table that corresponds to the nested table
   PARENT_TABLE_NAME
      Name of the parent table containing the nested table
   TABLE_TYPE_NAME
      Name of the type of the nested table
   TABLE_TYPE_OWNER
      Owner of the type of which the nested table was created
   OWNER
      Owner of the nested table
   TABLE_NAME
      Name of the nested table

Related Commands:




Back to the Top

Simon Sheppard
SS64.com