ALL_XML_SCHEMA_ELEMENTS
ALL_XML_SCHEMA_ELEMENTS describes all the elements and their properties accessible to the current user.
Related Views
-
DBA_XML_SCHEMA_ELEMENTSdescribes all the elements and their properties. -
USER_XML_SCHEMA_ELEMENTSdescribes all the elements and their properties owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | 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 |
|
TARGET_NAMESPACE |
VARCHAR2(2000) |
The namespace of the element | |
ELEMENT_NAME |
VARCHAR2(2000) |
Name of the element | |
IS_REF |
NUMBER |
Indicates whether an attribute was defined using a reference in the XML schema (1) or not (0) |
|
TYPE_NAME |
VARCHAR2(2000) |
Name of the type of the element | |
GLOBAL |
RAW(1) |
Indicates whether the attribute is global (1) or not (0) |
|
ELEMENT |
XMLTYPE |
The actual XML fragment of the element | |
SQL_INLINE |
RAW(1) |
XDB annotation for sqlInline | |
SQL_TYPE |
VARCHAR2(128) |
XDB annotation value for sqlType | |
SQL_SCHEMA |
VARCHAR2(128) |
XDB annotation value for sqlSchema | |
DEFAULT_TABLE |
VARCHAR2(128) |
XDB annotation value for default table | |
SQL_NAME |
VARCHAR2(128) |
XDB annotation value for sqlName | |
SQL_COL_TYPE |
VARCHAR2(128) |
XDB annotation value for sqlColType | |
MAINTAIN_DOM |
RAW(1) |
XDB annotation for maintainDOM | |
MAINTAIN_ORDER |
RAW(1) |
XDB annotation for maintainOrder | |
ELEMENT_ID |
RAW(20) |
Unique identifier for the element | |
PARENT_ELEMENT_ID |
RAW(20) |
Identies the parent of the element |
See Also:
-
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