[Home] [Help]
[Dependency Information]
VIEW: MDSYS.SDO_CRS_GEOGRAPHIC2D
Object Details
Object Name: | SDO_CRS_GEOGRAPHIC2D |
Object Type: | VIEW |
Owner: | MDSYS |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
SRID |
NUMBER |
(10) |
Yes |
|
COORD_REF_SYS_NAME |
VARCHAR2 |
(80) |
Yes |
|
COORD_SYS_ID |
NUMBER |
(10) |
|
|
DATUM_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
, DATUM_ID
, INFORMATION_SOURCE
, DATA_SOURCE
FROM MDSYS.SDO_CRS_GEOGRAPHIC2D;
Dependencies
[top of page]
MDSYS.SDO_CRS_GEOGRAPHIC2D references the following:
-
MDSYS
-
SDO_COORD_REF_SYS
MDSYS.SDO_CRS_GEOGRAPHIC2D is referenced by following:
-
MDSYS
-
SDO_CRS_INSERT_TRIGGER
-
PUBLIC
-
SDO_CRS_GEOGRAPHIC2D