Oracle教程 2023-03-25

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

Oracle视图ALL_XML_SCHEMAS提供了与XML类型有关的信息。它提供关于XML类型的基本信息，包括名称、拥有者、类型、URL、创建日期和更新日期，以及其他备注信息。

用途：

可以使用这个信息来分析XML类型所建立在什么基础之上，并且可以利用这个信息来调整相应的XML类型以更好地满足用户的需求。

使用方法：

可以使用SELECT语句查询ALL_XML_SCHEMA视图，通过这个视图可以得到关于XML类型的基本信息。例如，要获取类型ID为1的XML类型的概要信息，可以使用以下SELECT语句：

SELECT * FROM ALL_XML_SCHEMAS WHERE TYPE_ID=1;

ALL_XML_SCHEMAS describes the registered XML schemas accessible to the current user.

Related Views

DBA_XML_SCHEMAS describes all registered XML schemas in the database.
USER_XML_SCHEMAS describes the registered XML schemas owned by the current user. This view does not display the OWNER column.

Column	Datatype	Description
`OWNER`	`VARCHAR2(128)`	Owner of the XML schema
`SCHEMA_URL`	`VARCHAR2(700)`	Schema URL of the XML schema Refer to the See Also note below for links to more information about the `schemaurl` attribute for an XML schema.
`LOCAL`	`VARCHAR2(3)`	Indicates whether the XML schema is local (`YES`) or global (`NO`)
`SCHEMA`	`XMLTYPE`	XML schema document
`INT_OBJNAME`	`VARCHAR2(4000)`	Internal database object name for the schema
`QUAL_SCHEMA_URL`	`VARCHAR2(865)`	Fully qualified schema URL
`HIER_TYPE`	`VARCHAR2(11)`	Type of hierarchy for which the schema is enabled: `NONE` `RESMETADATA` `CONTENTS`
`BINARY`	`VARCHAR2(3)`	Indicates whether the XML Schema is registered for binary encoding usage (`YES`) or not (`NO`)
`SCHEMA_ID`	`RAW(16)`	Opaque schema identifier (16 bytes)
`HIDDEN`	`VARCHAR2(3)`	Indicates whether the XML Schema has been deleted in hidden mode (`YES`) or not (`NO`)