Oracle教程 2023-03-31

Oracle 视图 ALL_XML_SCHEMA_SUBSTGRP_MBRS 官方解释，作用，如何使用详细说明

ALL_XML_SCHEMA_SUBSTGRP_MBRS是Oracle中的系统视图，它用于显示XML Schema类型子元素组和单个元素成员之间的映射。

Oracle视图是一种特殊的逻辑表，可以在逻辑上访问表和其他数据对象中的数据。它不是一个物理结构，而是一种逻辑表，它可以存储关联的一组数据行，以及查询结果集。Oracle视图以一种抽象的方式将数据展示给用户，这就意味着用户只需编写一条查询语句，就可以从一个或多个不同表中检索数据。

要使用ALL_XML_SCHEMA_SUBSTGRP_MBRS视图，用户可以编写一条SELECT语句，以检索XML Schema类型子元素组和单个元素成员之间的映射。具体的SQL语句如下所示：

SELECT *
FROM all_xml_schema_substgrp_mbrs
WHERE owner_name = [schema_name];

ALL_XML_SCHEMA_SUBSTGRP_MBRS describes all members of substitution groups accessible to the current user.

Related Views

DBA_XML_SCHEMA_SUBSTGRP_MBRS describes all members of substitution groups.
USER_XML_SCHEMA_SUBSTGRP_MBRS describes all members of substitution groups owned by the current user. This view does not display the OWNER column.

Column	Datatype	Description
`OWNER`	`VARCHAR2(128)`	The user who owns the element
`SCHEMA_URL`	`VARCHAR2(700)`	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 `schemaurl` attribute for an XML schema.
`TARGET_NAMESPACE`	`VARCHAR2(2000)`	The namespace of the element
`ELEMENT_NAME`	`VARCHAR2(256)`	Name of the element
`ELEMENT`	`XMLTYPE(XMLSchema "http://xmlns.oracle.com/xdb/XDBSchema.xsd" Element "element")`	The actual XML fragment of the element
`HEAD_OWNER`	`VARCHAR2(128)`	The user who owns the head element for the current element
`HEAD_SCHEMA_URL`	`VARCHAR2(700)`	The URL of the schema within which the head element exists
`HEAD_TARGET_NAMESPACE`	`VARCHAR2(2000)`	The namespace of the head element
`HEAD_ELEMENT_NAME`	`VARCHAR2(256)`	Name of the head element
`HEAD_ELEMENT`	`XMLTYPE(XMLSchema "http://xmlns.oracle.com/xdb/XDBSchema.xsd" Element "element")`	The actual XMLType of the head element