[Home] [Help] [Dependency Information]
Object Name: | SDO_COORD_SYS |
---|---|
Object Type: | TABLE |
Owner: | MDSYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
COORDINATE_SYSTEM_PRIM | NORMAL | UNIQUE | SYSTEM | COORD_SYS_ID |
SYS_C00186535 | NORMAL | UNIQUE | SYSTEM | COORD_SYS_NAME |
SDO_COORD_SYS_COORD_SYS_TYPE | NORMAL | NONUNIQUE | SYSTEM | COORD_SYS_TYPE |
Table | |
Foreign Table | Foreign Key Column | SDO_COORD_AXES | SDO_COORD_SYS | SDO_COORD_AXES COORD_SYS_ID | SDO_COORD_REF_SYS | SDO_COORD_SYS | SDO_COORD_REF_SYS COORD_SYS_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COORD_SYS_ID | NUMBER | (10) | Yes | |
COORD_SYS_NAME | VARCHAR2 | (254) | Yes | |
COORD_SYS_TYPE | VARCHAR2 | (24) | ||
DIMENSION | NUMBER | (5) | ||
INFORMATION_SOURCE | VARCHAR2 | (254) | ||
DATA_SOURCE | VARCHAR2 | (50) |
Cut, paste (and edit) the following text to query this object:
SELECT COORD_SYS_ID
, COORD_SYS_NAME
, COORD_SYS_TYPE
, DIMENSION
, INFORMATION_SOURCE
, DATA_SOURCE
FROM MDSYS.SDO_COORD_SYS;
MDSYS.SDO_COORD_SYS does not reference any database object
MDSYS.SDO_COORD_SYS is referenced by following:
|
|
|