Oracle教程 2023-02-23

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_TYPES describes all complex types in the database.
USER_XML_SCHEMA_COMPLEX_TYPES describes all complex types owned by the current user. This view does not display the OWNER column.

Column	Datatype	Description
`OWNER`	`VARCHAR2(128)`	The user who owns the type
`SCHEMA_URL`	`VARCHAR2(700)`	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 `schemaurl` attribute for an XML schema.
`TARGET_NAMESPACE`	`VARCHAR2(2000)`	The namespace of the type
`COMPLEX_TYPE_NAME`	`VARCHAR2(256)`	Name of the complex type
`COMPLEX_TYPE`	`XMLTYPE(XMLSchema "http://xmlns.oracle.com/xdb/XDBSchema.xsd" Element "complexType")`	The actual XMLType of the type
`BASE_NAME`	`VARCHAR2(256)`	Name of the base type to which the complex type refers
`BASE_SCHEMA_URL`	`VARCHAR2(700)`	The URL of the schema within which the complex type is defined
`BASE_TARGET_NAMESPACE`	`VARCHAR2(2000)`	The namespace of the type
`MAINTAIN_DOM`	`RAW(1)`	XDB annotation for maintainDOM
`SQL_TYPE`	`VARCHAR2(128)`	XDB annotation for sqlType
`SQL_SCHEMA`	`VARCHAR2(128)`	XDB annotation for sqlSchema

本站中文解释

官方英文解释

相关推荐