ALL_XML_TABLES

ALL_XML_TABLES describes the XML tables accessible to the current user.

Related Views

• DBA_XML_TABLES describes all XML tables in the database.
• USER_XML_TABLES describes the XML tables owned by the current user. This view does not display the OWNER column.

  Column	Datatype	NULL	Description
  OWNER	VARCHAR2(30)		Owner of the XML table
  TABLE_NAME	VARCHAR2(30)		Name of the XML table
  XMLSCHEMA	VARCHAR2(700)		Name of the XML Schema that is used for the table definition
  SCHEMA_OWNER	VARCHAR2(30)		Owner of the XML Schema that is used for the table definition
  ELEMENT_NAME	VARCHAR2(256)		Name of the XML SChema element that is used for the table
  STORAGE_TYPE	VARCHAR2(17)		Storage option for the XMLtype data (OBJECT-RELATIONAL or CLOB)

  See Also: "DBA_XML_TABLES" "USER_XML_TABLES"