3.145 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:

• "DBA_XML_NESTED_TABLES"

• "USER_XML_NESTED_TABLES"