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(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_TAB_COLS" "USER_XML_TAB_COLS"