Oracle 视图 ALL_XML_SCHEMA_SUBSTGRP_HEAD 官方解释,作用,如何使用详细说明
本站中文解释
ERS
ALL_XML_SCHEMA_SUBSTGRP_HEADERS视图包含有关XML模式类型的所有替换组的概要信息。
替换组是用于存储XML数据和查询的抽象概念,用于XML模式集合和XMLType Profiles。
使用这个视图,可以检索有关所选模式类型的替换组的头信息,例如它的名称、大小、所有者、作者、描述等。
要使用 ALL_XML_SCHEMA_SUBSTGRP_HEADERS 视图,请在查询中指定 XML_SCHEMA_NAME 列的值,该值必须是 ALL_XML_SCHEMAS 中的值。
例如,要检索名为 empSchema 的 XML 模式的所有替换组的头:
SELECT *
FROM ALL_XML_SCHEMA_SUBSTGRP_HEADERS
WHERE XML_SCHEMA_NAME = ’empSchema’;
官方英文解释
ALL_XML_SCHEMA_SUBSTGRP_HEAD
describes the heads of substitution groups accessible to the current user.
Related Views
-
DBA_XML_SCHEMA_SUBSTGRP_HEAD
describes the heads of substitution groups. -
USER_XML_SCHEMA_SUBSTGRP_HEAD
describes the heads of substitution groups owned by the current user. This view does not display theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
The user who owns the element |
|
|
|
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 |
|
|
|
The namespace of the element |
|
|
|
Name of the element |
|
|
|
The actual XML fragment of the element |
See Also:
-
“DBA_XML_SCHEMA_SUBSTGRP_HEAD”
-
“USER_XML_SCHEMA_SUBSTGRP_HEAD”
-
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