Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_NESTED_TABLES

Description of nested tables contained in the user's own tables 

Columns
   ___________________________
 
   TABLE_NAME
      Name of the nested table
   TABLE_TYPE_OWNER
      Owner of the type of which the nested table was created
   TABLE_TYPE_NAME
      Name of the type of the nested table
   PARENT_TABLE_NAME
      Name of the parent table containing the nested table
   PARENT_TABLE_COLUMN
      Column name of the parent table that corresponds to the nested table
   STORAGE_SPEC
      --
   RETURN_TYPE
      --
   ELEMENT_SUBSTITUTABLE
      Indication of whether the nested table element is substitutable or not

Related:


Simon Sheppard
 SS64.com