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_ELEMENTSdescribes all the elements and their properties.USER_XML_SCHEMA_ELEMENTSdescribes all the elements and their properties owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
| The user who owns the element | |
|
| 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 | |
|
| The namespace of the element | |
|
| Name of the element | |
|
| Indicates whether an attribute was defined using a reference in the XML schema ( | |
|
| Name of the type of the element | |
|
| Indicates whether the attribute is global ( | |
|
| The actual XML fragment of the element | |
|
| XDB annotation for sqlInline | |
|
| XDB annotation value for sqlType | |
|
| XDB annotation value for sqlSchema | |
|
| XDB annotation value for default table | |
|
| XDB annotation value for sqlName | |
|
| XDB annotation value for sqlColType | |
|
| XDB annotation for maintainDOM | |
|
| XDB annotation for maintainOrder | |
|
| Unique identifier for the element | |
|
| Identies the parent of the element |
See Also:
“DBA_XML_SCHEMA_ELEMENTS”
“USER_XML_SCHEMA_ELEMENTS”
Oracle XML DB Developer’s
Guide for information about registering an XML schema with Oracle XML DBOracle XML DB Developer’s
Guide for information about restrictions for an XML schema URL
编辑：广州明生医药有限公司
标签：类型,元素,定义,节点,名称