[Home] [Help] [Dependency Information]
Object Name: | ALL_XML_SCHEMA_ELEMENTS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | ||
SCHEMA_URL | VARCHAR2 | (700) | ||
TARGET_NAMESPACE | VARCHAR2 | (2000) | ||
ELEMENT_NAME | VARCHAR2 | (2000) | ||
IS_REF | NUMBER | |||
TYPE_NAME | VARCHAR2 | (2000) | ||
GLOBAL | RAW | (1) | ||
ELEMENT | XMLTYPE | (64) | ||
SQL_INLINE | RAW | (1) | ||
SQL_TYPE | VARCHAR2 | (128) | ||
SQL_SCHEMA | VARCHAR2 | (128) | ||
DEFAULT_TABLE | VARCHAR2 | (128) | ||
SQL_NAME | VARCHAR2 | (128) | ||
SQL_COL_TYPE | VARCHAR2 | (128) | ||
MAINTAIN_DOM | RAW | (1) | ||
MAINTAIN_ORDER | RAW | (1) | ||
ELEMENT_ID | RAW | (20) | ||
PARENT_ELEMENT_ID | RAW | (20) |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, SCHEMA_URL
, TARGET_NAMESPACE
, ELEMENT_NAME
, IS_REF
, TYPE_NAME
, GLOBAL
, ELEMENT
, SQL_INLINE
, SQL_TYPE
, SQL_SCHEMA
, DEFAULT_TABLE
, SQL_NAME
, SQL_COL_TYPE
, MAINTAIN_DOM
, MAINTAIN_ORDER
, ELEMENT_ID
, PARENT_ELEMENT_ID
FROM SYS.ALL_XML_SCHEMA_ELEMENTS;
|
|
|