[Home] [Help] [Dependency Information]
Object Name: | SDO_UNITS_OF_MEASURE |
---|---|
Object Type: | TABLE |
Owner: | MDSYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
UNIT_OF_MEASURE_PRIM | NORMAL | UNIQUE | SYSTEM | UOM_ID |
UOM_UNIQUE_SHORT_NAME | NORMAL | UNIQUE | SYSAUX | SHORT_NAME |
Table | |
Foreign Table | Foreign Key Column | SDO_UNITS_OF_MEASURE | SDO_ELLIPSOIDS | SDO_UNITS_OF_MEASURE LEGACY_CODE | SDO_UNITS_OF_MEASURE | SDO_UNITS_OF_MEASURE | SDO_UNITS_OF_MEASURE LEGACY_CODE | SDO_UNITS_OF_MEASURE | SDO_UNITS_OF_MEASURE | SDO_UNITS_OF_MEASURE TARGET_UOM_ID | SDO_COORD_AXES | SDO_UNITS_OF_MEASURE | SDO_COORD_AXES UOM_ID | SDO_COORD_OP_PARAM_VALS | SDO_UNITS_OF_MEASURE | SDO_COORD_OP_PARAM_VALS UOM_ID | SDO_ELLIPSOIDS | SDO_UNITS_OF_MEASURE | SDO_ELLIPSOIDS UOM_ID | SDO_PRIME_MERIDIANS | SDO_UNITS_OF_MEASURE | SDO_PRIME_MERIDIANS UOM_ID | SDO_UNITS_OF_MEASURE | SDO_UNITS_OF_MEASURE | SDO_UNITS_OF_MEASURE LEGACY_CODE | SDO_UNITS_OF_MEASURE | SDO_UNITS_OF_MEASURE | SDO_UNITS_OF_MEASURE TARGET_UOM_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UOM_ID | NUMBER | (10) | Yes | |
UNIT_OF_MEAS_NAME | VARCHAR2 | (2083) | Yes | |
SHORT_NAME | VARCHAR2 | (80) | ||
LEGACY_UNIT_NAME | VARCHAR2 | (80) | ||
UNIT_OF_MEAS_TYPE | VARCHAR2 | (50) | ||
TARGET_UOM_ID | NUMBER | (10) | ||
FACTOR_B | NUMBER | |||
FACTOR_C | NUMBER | |||
INFORMATION_SOURCE | VARCHAR2 | (254) | ||
DATA_SOURCE | VARCHAR2 | (40) | ||
IS_LEGACY | VARCHAR2 | (5) | Yes | |
LEGACY_CODE | NUMBER | (10) |
Cut, paste (and edit) the following text to query this object:
SELECT UOM_ID
, UNIT_OF_MEAS_NAME
, SHORT_NAME
, LEGACY_UNIT_NAME
, UNIT_OF_MEAS_TYPE
, TARGET_UOM_ID
, FACTOR_B
, FACTOR_C
, INFORMATION_SOURCE
, DATA_SOURCE
, IS_LEGACY
, LEGACY_CODE
FROM MDSYS.SDO_UNITS_OF_MEASURE;
MDSYS.SDO_UNITS_OF_MEASURE does not reference any database object
MDSYS.SDO_UNITS_OF_MEASURE is referenced by following:
|
|
|