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 NULL 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

See Also: