Oracle教程 2023-02-23

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

ALL_XML_SCHEMA_ELEMENTS 是Oracle的内置视图，它显示在数据库中所有用户的XML类型的定义中的xml元素。

它用于根据XML类型的定义查找XML元素名称和类型，比如它显示XML类型的定义，包括节点的名称、XML的类型、节点的属性和子元素。

此类查找可以帮助开发人员从XML文档中提取信息和构造语句。

使用方法：

查找某个用户定义的XML View：
SELECT * FROM ALL_XML_SCHEMA_ELEMENTS WHERE OWNER = ”;

查找指定XML View中的某一元素：
SELECT * FROM ALL_XML_SCHEMA_ELEMENTS
WHERE TYPE_NAME = ”
AND OWNER = ”
AND ELEMENT_NAME = ”;

ALL_XML_SCHEMA_ELEMENTS describes all the elements and their properties accessible to the current user.

Related Views

DBA_XML_SCHEMA_ELEMENTS describes all the elements and their properties.
USER_XML_SCHEMA_ELEMENTS describes all the elements and their properties owned by the current user. This view does not display the OWNER column.

Column	Datatype	Description
`OWNER`	`VARCHAR2(128)`	The user who owns the element
`SCHEMA_URL`	`VARCHAR2(700)`	The URL of the schema within which the element is defined Refer to the See Also note below for links to more information about the `schemaurl` attribute for an XML schema.
`TARGET_NAMESPACE`	`VARCHAR2(2000)`	The namespace of the element
`ELEMENT_NAME`	`VARCHAR2(2000)`	Name of the element
`IS_REF`	`NUMBER`	Indicates whether an attribute was defined using a reference in the XML schema (`1`) or not (`0`)
`TYPE_NAME`	`VARCHAR2(2000)`	Name of the type of the element
`GLOBAL`	`RAW(1)`	Indicates whether the attribute is global (`1`) or not (`0`)
`ELEMENT`	`XMLTYPE`	The actual XML fragment of the element
`SQL_INLINE`	`RAW(1)`	XDB annotation for sqlInline
`SQL_TYPE`	`VARCHAR2(128)`	XDB annotation value for sqlType
`SQL_SCHEMA`	`VARCHAR2(128)`	XDB annotation value for sqlSchema
`DEFAULT_TABLE`	`VARCHAR2(128)`	XDB annotation value for default table
`SQL_NAME`	`VARCHAR2(128)`	XDB annotation value for sqlName
`SQL_COL_TYPE`	`VARCHAR2(128)`	XDB annotation value for sqlColType
`MAINTAIN_DOM`	`RAW(1)`	XDB annotation for maintainDOM
`MAINTAIN_ORDER`	`RAW(1)`	XDB annotation for maintainOrder
`ELEMENT_ID`	`RAW(20)`	Unique identifier for the element
`PARENT_ELEMENT_ID`	`RAW(20)`	Identies the parent of the element