ALL_XML_TAB_COLS

ALL_XML_TAB_COLS describes the columns of the XML tables accessible to the current user.

Related Views

DBA_XML_TAB_COLS describes the columns of all XML tables in the database.
USER_XML_TAB_COLS describes the columns of the XML tables owned by the current user. This view does not display the OWNER column.

Column	Datatype	Description
`OWNER`	`VARCHAR2(30)`	Owner of the XML table
`TABLE_NAME`	`VARCHAR2(30)`	Name of the XML table
`COLUMN_NAME`	`VARCHAR2(4000)`	Name of the XML table column
`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