Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-23
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_XML_TAB_COLS

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

Related Views

Column Datatype NULL Description
OWNER VARCHAR2(128)   Owner of the XML table
TABLE_NAME VARCHAR2(128)   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(128)   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

Note: The CLOB storage option for XMLType data is deprecated in Oracle Database 12c Release 1 (12.1). Oracle recommends using the BINARY storage option, instead.

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