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]

TABLE: MDSYS.WFS_FEATURETYPEXMLCOLINFO$

Object Details

Object Name:	WFS_FEATURETYPEXMLCOLINFO$
Object Type:	TABLE
Owner:	MDSYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: SYS_C00236177

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_C00236177	NORMAL	UNIQUE	SYSTEM	ID
SYS_IL0000489318C00005$$	LOB	UNIQUE	SYSTEM
SYS_IL0000489318C00007$$	LOB	UNIQUE	SYSTEM
SYS_IL0000489318C00009$$	LOB	UNIQUE	SYSTEM

Foreign Keys

Table		Foreign Table	Foreign Key Column
WFS_FEATURETYPEXMLCOLINFO$		WFS_FEATURETYPE$	WFS_FEATURETYPEXMLCOLINFO$ FEATURETYPEID

Columns

Name	Datatype	Length	Mandatory
ID	NUMBER		Yes
FEATURETYPEID	NUMBER
FTNAMESPACEURL	VARCHAR2	(2083)
XSDDESC	XMLTYPE	(2000)
XSDWRAPPERDESC	XMLTYPE	(2000)
COLUMNNAME	VARCHAR2	(30)
OBJPATHINFO	STRINGLIST	(3752)
LASTUPDATETS	TIMESTAMP(6)	(11)
LASTWRAPPERGENERATETS	TIMESTAMP(6)	(11)

Query Text

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


SELECT ID
,      FEATURETYPEID
,      FTNAMESPACEURL
,      XSDDESC
,      XSDWRAPPERDESC
,      COLUMNNAME
,      OBJPATHINFO
,      LASTUPDATETS
,      LASTWRAPPERGENERATETS
FROM MDSYS.WFS_FEATURETYPEXMLCOLINFO$;

Dependencies

[top of page]

MDSYS.WFS_FEATURETYPEXMLCOLINFO$ references the following:

MDSYS: STRINGLIST
PUBLIC: XMLTYPE
SYS: STANDARD - show dependent code; XMLTYPE

MDSYS.WFS_FEATURETYPEXMLCOLINFO$ is referenced by following:

MDSYS: SDO_WFS_PROCESS - show dependent code