Oracle 视图 ALL_XML_SCHEMA_COMPLEX_TYPES 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图 ALL_XML_SCHEMA_COMPLEX_TYPES 用于描述当前用户或当前用户的模式下存在的所有复杂XML模式类型信息。
它的完整的列如下：
OWNER：此复杂XML模式类型的模式拥有者
SCHEMA_NAME：此XML模式文档的模式名称
TYPE_NAME：此XML模式类型的名称
FINAL_VERSION：指示此XML模式类型是否为不可修改
IS_ABSTRACT：指示此XML Schema类型是否为抽象
IS_COMPLEX：指示此XML Schema类型是否为复杂
DERIVATION_METHOD：成员派生模式的派生方法
SCOPE_OID：此XML模式类型的标识符号
这个视图可以帮助用户获取模式文档下定义的所有复杂XML模式类型的属性信息，帮助用户理解XML Schema的复杂性及派生方式。
使用方法:
示例：查找所有属于模式 SCOTT 的复杂XML模式类型
SELECT *
FROM ALL_XML_SCHEMA_COMPLEX_TYPES
WHERE OWNER = ‘SCOTT’
示例：查找模式 SCOTT 下所有“不可修改”的XML模式类型
SELECT *
FROM ALL_XML_SCHEMA_COMPLEX_TYPES
WHERE OWNER = ‘SCOTT’
AND FINAL_VERSION = ‘TRUE’
官方英文解释
ALL_XML_SCHEMA_COMPLEX_TYPES describes all complex types accessible to the current user.
Related Views
DBA_XML_SCHEMA_COMPLEX_TYPESdescribes all complex types in the database.USER_XML_SCHEMA_COMPLEX_TYPESdescribes all complex types owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
| The user who owns the type | |
|
| The URL of the schema within which the type is defined Refer to the See Also note below for links to more information about the | |
|
| The namespace of the type | |
|
| Name of the complex type | |
|
| The actual XMLType of the type | |
|
| Name of the base type to which the complex type refers | |
|
| The URL of the schema within which the complex type is defined | |
|
| The namespace of the type | |
|
| XDB annotation for maintainDOM | |
|
| XDB annotation for sqlType | |
|
| XDB annotation for sqlSchema |
See Also:
“DBA_XML_SCHEMA_COMPLEX_TYPES”
“USER_XML_SCHEMA_COMPLEX_TYPES”
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
编辑：广州明生医药有限公司
标签：模式,类型,用户,指示,视图