1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: ALL_PART_COL_STATISTICS to DATABASE_PROPERTIES
  4. ALL_XML_NESTED_TABLES

3.142 ALL_XML_NESTED_TABLES

ALL_XML_NESTED_TABLES describes all the tables and their corresponding nested tables accessible to the current user.

Related Views

  • DBA_XML_NESTED_TABLES describes all the tables and their corresponding nested tables in the database.

  • USER_XML_NESTED_TABLES describes all the tables and their corresponding nested tables owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

Owner of the table

TABLE_NAME

VARCHAR2(128)

Name of the table

NESTED_TABLE_NAME

VARCHAR2(128)

Name of the nested table

PARENT_COLUMN_NAME

VARCHAR2(4000)

Name of the parent XML column

See Also: