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_FEATURETYPE$

Object Details

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

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: SYS_C00236171

FEATURETYPEID

Unique Key: UNIQUE_WFS_FT_COND

NAMESPACEURL
FEATURETYPENAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_C00236171	NORMAL	UNIQUE	SYSTEM	FEATURETYPEID
SYS_IL0000489269C00004$$	LOB	UNIQUE	SYSTEM
SYS_IL0000489269C00006$$	LOB	UNIQUE	SYSTEM
SYS_IL0000489269C00015$$	LOB	UNIQUE	SYSTEM
SYS_IL0000489269C00016$$	LOB	UNIQUE	SYSTEM
SYS_IL0000489269C00017$$	LOB	UNIQUE	SYSTEM
SYS_IL0000489269C00018$$	LOB	UNIQUE	SYSTEM
SYS_IL0000489269C00019$$	LOB	UNIQUE	SYSTEM
SYS_IL0000489269C00026$$	LOB	UNIQUE	SYSTEM
SYS_IL0000489269C00027$$	LOB	UNIQUE	SYSTEM
SYS_IL0000489269C00028$$	LOB	UNIQUE	SYSTEM
SYS_IL0000489269C00029$$	LOB	UNIQUE	SYSTEM
SYS_IL0000489269C00030$$	LOB	UNIQUE	SYSTEM
SYS_IL0000489269C00031$$	LOB	UNIQUE	SYSTEM
SYS_IL0000489269C00034$$	LOB	UNIQUE	SYSTEM
SYS_IL0000489269C00035$$	LOB	UNIQUE	SYSTEM
SYS_IL0000489269C00037$$	LOB	UNIQUE	SYSTEM
SYS_IL0000489269C00038$$	LOB	UNIQUE	SYSTEM
SYS_IL0000489269C00039$$	LOB	UNIQUE	SYSTEM
UNIQUE_WFS_FT_COND	NORMAL	UNIQUE	SYSTEM	NAMESPACEURL FEATURETYPENAME

Foreign Keys

Table	Foreign Table	Foreign Key Column
WFS_FEATUREINSTANCEMETADATA$	WFS_FEATURETYPE$	WFS_FEATUREINSTANCEMETADATA$ FEATURETYPEID
WFS_FEATURETYPEATTRS$	WFS_FEATURETYPE$	WFS_FEATURETYPEATTRS$ FEATURETYPEID
WFS_FEATURETYPENESTEDSDOS$	WFS_FEATURETYPE$	WFS_FEATURETYPENESTEDSDOS$ FEATURETYPEID
WFS_FEATURETYPESIMPLETAGATTRS$	WFS_FEATURETYPE$	WFS_FEATURETYPESIMPLETAGATTRS$ FEATURETYPEID
WFS_FEATURETYPETAGS$	WFS_FEATURETYPE$	WFS_FEATURETYPETAGS$ FEATURETYPEID
WFS_FEATURETYPEXMLCOLINFO$	WFS_FEATURETYPE$	WFS_FEATURETYPEXMLCOLINFO$ FEATURETYPEID

Columns

Name	Datatype	Length	Mandatory
FEATURETYPEID	NUMBER		Yes
FEATURETYPENAME	VARCHAR2	(80)
FEATUREDESC	XMLTYPE	(2000)
DESCRIBEFEATURETYPE	XMLTYPE	(2000)
LASTDESCRIBEFEATURETYPEGENTS	TIMESTAMP(6)	(11)
LASTFEATUREUPDATETS	TIMESTAMP(6)	(11)
NAMESPACEPREFIX	VARCHAR2	(20)
NAMESPACEURL	VARCHAR2	(2083)
SCHEMALOCATION	VARCHAR2	(2083)
KEYCOLS	VARCHAR2	(4000)
DATAPOINTER	VARCHAR2	(61)
ISDOCBASED	VARCHAR2	(1)
SPATIALCOLS	STRINGLIST	(3752)
MANDATORYCOLS	STRINGLIST	(3752)
TSCOLS	STRINGLIST	(3752)
DOCIDPATHS	STRINGLIST	(3752)
SPATIALPATHARRSEP	STRINGLIST	(3752)
PRIMARYSPATIALCOL	VARCHAR2	(4000)
FEATUREMEMBERNAME	VARCHAR2	(2200)
SRSNS	VARCHAR2	(2083)
SRSNSALIAS	VARCHAR2	(80)
FTXSDREFID	VARCHAR2	(80)
ISMTABLEVIEW	VARCHAR2	(1)
VTABLELIST	STRINGLIST	(3752)
VKEYCOLSLIST	STRINGLIST	(3752)
TKEYCOLSLIST	STRINGLIST	(3752)
NUMCOLS	STRINGLIST	(3752)
IDXPATHS	STRINGLIST	(3752)
IDXPATHTYPES	STRINGLIST	(3752)
XTIDXCREATED	VARCHAR2	(1)
FEATURECOLLECTIONNAME	VARCHAR2	(2200)
FORMATTEDKEYCOLS	STRINGLIST	(3752)
FORMATTEDTKEYCOLLIST	STRINGLISTLIST	(3752)
ISGML3	VARCHAR2	(1)
SPATIALARRLIST	STRINGLISTLIST	(3752)
SPATIALPATHSSRSNSLIST	STRINGLISTLIST	(3752)
SPATIALARRPATHSSRSNSLIST	STRINGLISTLIST	(3752)
WFS_VERSION	VARCHAR2	(20)

Query Text

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


SELECT FEATURETYPEID
,      FEATURETYPENAME
,      FEATUREDESC
,      DESCRIBEFEATURETYPE
,      LASTDESCRIBEFEATURETYPEGENTS
,      LASTFEATUREUPDATETS
,      NAMESPACEPREFIX
,      NAMESPACEURL
,      SCHEMALOCATION
,      KEYCOLS
,      DATAPOINTER
,      ISDOCBASED
,      SPATIALCOLS
,      MANDATORYCOLS
,      TSCOLS
,      DOCIDPATHS
,      SPATIALPATHARRSEP
,      PRIMARYSPATIALCOL
,      FEATUREMEMBERNAME
,      SRSNS
,      SRSNSALIAS
,      FTXSDREFID
,      ISMTABLEVIEW
,      VTABLELIST
,      VKEYCOLSLIST
,      TKEYCOLSLIST
,      NUMCOLS
,      IDXPATHS
,      IDXPATHTYPES
,      XTIDXCREATED
,      FEATURECOLLECTIONNAME
,      FORMATTEDKEYCOLS
,      FORMATTEDTKEYCOLLIST
,      ISGML3
,      SPATIALARRLIST
,      SPATIALPATHSSRSNSLIST
,      SPATIALARRPATHSSRSNSLIST
,      WFS_VERSION
FROM MDSYS.WFS_FEATURETYPE$;

Dependencies

[top of page]

MDSYS.WFS_FEATURETYPE$ references the following:

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

MDSYS.WFS_FEATURETYPE$ is referenced by following:

MDSYS: SDO_WFS_PROCESS - show dependent code