[Home] [Help] [Dependency Information]

TABLE: MDSYS.SDO_UNITS_OF_MEASURE

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: UNIT_OF_MEASURE_PRIM

1. UOM_ID

Unique Key: UOM_UNIQUE_SHORT_NAME

1. SHORT_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
UNIT_OF_MEASURE_PRIM	NORMAL	UNIQUE	SYSTEM	UOM_ID
UOM_UNIQUE_SHORT_NAME	NORMAL	UNIQUE	SYSAUX	SHORT_NAME

Foreign Keys

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

Columns

Query Text

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;

Dependencies

[top of page]

MDSYS.SDO_UNITS_OF_MEASURE does not reference any database object

MDSYS.SDO_UNITS_OF_MEASURE is referenced by following:

MDSYS

SDO_ANGLE_UNITS

SDO_AREA_UNITS

SDO_CS - show dependent code

SDO_DIST_UNITS

SDO_UNITS_OF_MEASURE_TRIGGER

PUBLIC

SDO_UNITS_OF_MEASURE