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 DBOracle XML DB Developer’s
Guide for information about restrictions for an XML schema URL
编辑：广州明生医药有限公司
标签：模式,视图,属性,类型,用户可以