eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.USER_XML_SCHEMA_ELEMENTS

Object Details

Object Name:	USER_XML_SCHEMA_ELEMENTS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
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)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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.USER_XML_SCHEMA_ELEMENTS;

Dependencies

[top of page]

SYS.USER_XML_SCHEMA_ELEMENTS references the following:

SYS: DBA_XML_SCHEMA_ELEMENTS; PARENTIDARRAY; PRVTPARENTCHILD - show dependent code; STANDARD - show dependent code; XMLTYPE

SYS.USER_XML_SCHEMA_ELEMENTS is referenced by following:

PUBLIC: USER_XML_SCHEMA_ELEMENTS