[Home] [Help]
[Dependency Information]
TABLE: MDSYS.SDO_CS_SRS
Object Details
Object Name: | SDO_CS_SRS |
Object Type: | TABLE |
Owner: | MDSYS |
Subobject Name: | |
Status: | VALID |
Storage Details
Tablespace: | SYSAUX |
PCT Free: | 10 |
PCT Used: | |
Primary Key: SYS_C00278693
- SRID
Indexes
Index |
Type |
Uniqueness |
Tablespace |
Column |
SYS_C00278693
|
NORMAL
|
UNIQUE
|
SYSAUX
|
SRID
|
SYS_IL0001107682C00012$$
|
LOB
|
UNIQUE
|
SYSAUX
|
|
SYS_IL0001107682C00013$$
|
LOB
|
UNIQUE
|
SYSAUX
|
|
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
CS_NAME |
VARCHAR2 |
(80) |
|
|
SRID |
NUMBER |
|
Yes |
|
AUTH_SRID |
NUMBER |
|
|
|
AUTH_NAME |
VARCHAR2 |
(256) |
|
|
WKTEXT |
VARCHAR2 |
(2046) |
|
|
CS_BOUNDS |
SDO_GEOMETRY |
(1) |
|
|
WKTEXT3D |
VARCHAR2 |
(4000) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT CS_NAME
, SRID
, AUTH_SRID
, AUTH_NAME
, WKTEXT
, CS_BOUNDS
, WKTEXT3D
FROM MDSYS.SDO_CS_SRS;
Dependencies
[top of page]
MDSYS.SDO_CS_SRS references the following:
-
MDSYS
-
SDO_ELEM_INFO_ARRAY
-
SDO_GEOMETRY
-
SDO_ORDINATE_ARRAY
-
SYS
-
STANDARD
- show dependent code
MDSYS.SDO_CS_SRS is referenced by following:
-
MDSYS
-
CS_SRS
-
SDO_COORD_OP_PARAM_VAL_TRIGG2
-
SDO_COORD_OP_PARAM_VAL_TRIGGER
-
SDO_CRS_DELETE_TRIGGER
-
SDO_CRS_INSERT_TRIGGER
-
SDO_CS
- show dependent code
-
SDO_CS_SRS_SRID_INSERT
-
SDO_CS_SRS_SRID_UPDATE