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: MDSYS.SDO_COORD_REF_SYSTEM

Object Details

Object Name:	SDO_COORD_REF_SYSTEM
Object Type:	VIEW
Owner:	MDSYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
SRID	NUMBER	(10)	Yes
COORD_REF_SYS_NAME	VARCHAR2	(80)	Yes
COORD_REF_SYS_KIND	VARCHAR2	(24)	Yes
COORD_SYS_ID	NUMBER	(10)
DATUM_ID	NUMBER	(10)
GEOG_CRS_DATUM_ID	NUMBER	(10)
SOURCE_GEOG_SRID	NUMBER	(10)
PROJECTION_CONV_ID	NUMBER	(10)
CMPD_HORIZ_SRID	NUMBER	(10)
CMPD_VERT_SRID	NUMBER	(10)
INFORMATION_SOURCE	VARCHAR2	(254)
DATA_SOURCE	VARCHAR2	(40)
IS_LEGACY	VARCHAR2	(5)	Yes
LEGACY_CODE	NUMBER	(10)
LEGACY_WKTEXT	VARCHAR2	(2046)
LEGACY_CS_BOUNDS	SDO_GEOMETRY	(64)
IS_VALID	VARCHAR2	(5)
SUPPORTS_SDO_GEOMETRY	VARCHAR2	(5)

Query Text

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


SELECT SRID
,      COORD_REF_SYS_NAME
,      COORD_REF_SYS_KIND
,      COORD_SYS_ID
,      DATUM_ID
,      GEOG_CRS_DATUM_ID
,      SOURCE_GEOG_SRID
,      PROJECTION_CONV_ID
,      CMPD_HORIZ_SRID
,      CMPD_VERT_SRID
,      INFORMATION_SOURCE
,      DATA_SOURCE
,      IS_LEGACY
,      LEGACY_CODE
,      LEGACY_WKTEXT
,      LEGACY_CS_BOUNDS
,      IS_VALID
,      SUPPORTS_SDO_GEOMETRY
FROM MDSYS.SDO_COORD_REF_SYSTEM;

Dependencies

[top of page]

MDSYS.SDO_COORD_REF_SYSTEM references the following:

MDSYS: SDO_COORD_REF_SYS; SDO_GEOMETRY
SYS: STANDARD - show dependent code

MDSYS.SDO_COORD_REF_SYSTEM is referenced by following:

MDSYS: CS_SRS_TRIGGER; OGIS_CRS_DELETE_TRIGGER; OGIS_CRS_INSERT_TRIGGER; SDO_CRS_DELETE_TRIGGER; SDO_CRS_INSERT_TRIGGER
PUBLIC: SDO_COORD_REF_SYSTEM