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(2000)   Name of the XML SChema element that is used for the table
STORAGE_TYPE VARCHAR2(17)   Storage option for the XMLtype data:

  • OBJECT-RELATIONAL

  • BINARY

  • CLOB
ANYSCHEMA VARCHAR2(3)   If storage is BINARY, indicates whether the column allows ANYSCHEMA (YES) or not (NO), else NULL
NONSCHEMA VARCHAR2(3)   If storage is BINARY, indicates whether the column allows NONSCHEMA (YES) or not (NO), else NULL

See Also: