[Home] [Help] [Dependency Information]
Object Name: | SDO_DATUMS |
---|---|
Object Type: | TABLE |
Owner: | MDSYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
DATUM_PRIM | NORMAL | UNIQUE | SYSTEM | DATUM_ID |
SDO_DATUMS_DATUM_TYPE | NORMAL | NONUNIQUE | SYSTEM | DATUM_TYPE |
Table | |
Foreign Table | Foreign Key Column | SDO_DATUMS | SDO_DATUMS | SDO_DATUMS LEGACY_CODE | SDO_DATUMS | SDO_ELLIPSOIDS | SDO_DATUMS ELLIPSOID_ID | SDO_DATUMS | SDO_PRIME_MERIDIANS | SDO_DATUMS PRIME_MERIDIAN_ID | SDO_COORD_REF_SYS | SDO_DATUMS | SDO_COORD_REF_SYS DATUM_ID | SDO_DATUMS | SDO_DATUMS | SDO_DATUMS LEGACY_CODE |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATUM_ID | NUMBER | (10) | Yes | |
DATUM_NAME | VARCHAR2 | (80) | Yes | |
DATUM_TYPE | VARCHAR2 | (24) | ||
ELLIPSOID_ID | NUMBER | (10) | ||
PRIME_MERIDIAN_ID | NUMBER | (10) | ||
INFORMATION_SOURCE | VARCHAR2 | (254) | ||
DATA_SOURCE | VARCHAR2 | (40) | ||
SHIFT_X | NUMBER | |||
SHIFT_Y | NUMBER | |||
SHIFT_Z | NUMBER | |||
ROTATE_X | NUMBER | |||
ROTATE_Y | NUMBER | |||
ROTATE_Z | NUMBER | |||
SCALE_ADJUST | NUMBER | |||
IS_LEGACY | VARCHAR2 | (5) | Yes | |
LEGACY_CODE | NUMBER | (10) |
Cut, paste (and edit) the following text to query this object:
SELECT DATUM_ID
, DATUM_NAME
, DATUM_TYPE
, ELLIPSOID_ID
, PRIME_MERIDIAN_ID
, INFORMATION_SOURCE
, DATA_SOURCE
, SHIFT_X
, SHIFT_Y
, SHIFT_Z
, ROTATE_X
, ROTATE_Y
, ROTATE_Z
, SCALE_ADJUST
, IS_LEGACY
, LEGACY_CODE
FROM MDSYS.SDO_DATUMS;
MDSYS.SDO_DATUMS does not reference any database object
MDSYS.SDO_DATUMS is referenced by following:
|
|
|