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_CRS_PROJECTED

Object Details

Object Name:	SDO_CRS_PROJECTED
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_SYS_ID	NUMBER	(10)
SOURCE_GEOG_SRID	NUMBER	(10)
PROJECTION_CONV_ID	NUMBER	(10)
INFORMATION_SOURCE	VARCHAR2	(254)
DATA_SOURCE	VARCHAR2	(40)

Query Text

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


SELECT SRID
,      COORD_REF_SYS_NAME
,      COORD_SYS_ID
,      SOURCE_GEOG_SRID
,      PROJECTION_CONV_ID
,      INFORMATION_SOURCE
,      DATA_SOURCE
FROM MDSYS.SDO_CRS_PROJECTED;

Dependencies

[top of page]

MDSYS.SDO_CRS_PROJECTED references the following:

MDSYS: SDO_COORD_REF_SYS

MDSYS.SDO_CRS_PROJECTED is referenced by following:

PUBLIC: SDO_CRS_PROJECTED