Oracle 视图 ALL_XML_SCHEMA_ATTRIBUTES 官方解释，作用，如何使用详细说明
本站中文解释
ALL_XML_SCHEMA_ATTRIBUTES（所有XML模式属性）视图显示从字典视图ALL_XML_SCHEMAS中反引用的所有XML模式属性，这些XML模式可以被用户自己创建，或者从存储在数据库中的外部XML模式反引用。
视图中的所有列都可以在ALL_XML_SCHEMAS视图中找到。
使用ALL_XML_SCHEMA_ATTRIBUTES（所有XML模式属性）视图时，需要具有SELECT对象权限。
ALL_XML_SCHEMA_ATTRIBUTES（所有XML模式属性）视图可以帮助用户查询XML类型中的属性，以及指定模式的模式元素及其属性类型。 例如，用户可以查询指定模式的属性及其类型。 使用该视图，用户可以使用SQL查找哪些模式定义了何种属性以及每个属性的类型。
官方英文解释
ALL_XML_SCHEMA_ATTRIBUTES describes all the attributes and their properties accessible to the current user.
Related Views
-
DBA_XML_SCHEMA_ATTRIBUTESdescribes all the attributes and their properties accessible to the current user in the database. -
USER_XML_SCHEMA_ATTRIBUTESdescribes all the attributes and their properties owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
The user who owns the attribute |
|
|
|
|
The URL of the schema within which the attribute is defined Refer to the See Also note below for links to more information about the |
|
|
|
|
The namespace of the attribute |
|
|
|
|
Name of the attribute |
|
|
|
|
Indicates whether an attribute was defined using a reference in the XML schema ( |
|
|
|
|
Name of the type of the attribute |
|
|
|
|
Indicates whether the attribute is global ( |
|
|
|
|
Actual XMLType for the attribute |
|
|
|
|
Element ID of the element to which the attribute belongs |
|
|
|
|
XDB annotation for sqlType |
|
|
|
|
XDB annotation value for sqlName |
See Also:
-
“DBA_XML_SCHEMA_ATTRIBUTES”
-
“USER_XML_SCHEMA_ATTRIBUTES”
-
Oracle XML DB Developer’s
Guide for information about registering an XML schema with Oracle XML DB -
Oracle XML DB Developer’s
Guide for information about restrictions for an XML schema URL
