Oracle教程 2023-02-23

Oracle 视图 ALL_XML_TAB_COLS 官方解释，作用，如何使用详细说明

本站中文解释

ALL_XML_TAB_COLS 视图显示当前用户拥有的XMLType列的相关信息，保存有XMLSchema地址和XMLSchema权重等信息。可以使用该视图获取分析XMLType列所需信息。

该视图中的字段有：
TABLE_NAME: XMLType列所在的表名
COLUMNNAME: XMLType列的列名
XMLSCHEMALOCATION: XMLSchema所在路径
XMLSCHEMACOLLECTION: XMLSchema被绑定到XMLType列的XMLSchemaCollection类型名
WEIGHT: 更新xmlschema集合中XMLSchema权重

我们可以使用该视图来查询指定表中的XMLSchema信息：
SELECT TABLE_NAME, COLUMN_NAME, XMLSCHEMALOCATION, XMLSCHEMACOLLECTION, WEIGHT
FROM ALL_XML_TAB_COLS
WHERE TABLE_NAME = ‘TABLE_NAME’

官方英文解释

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(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
`TOKENSETS`	`VARCHAR2(4000)`	This column is for internal use only.

本站中文解释

官方英文解释

相关推荐