eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: MDSYS.SDO_DIST_UNITS

Source

View Text - Preformatted


SELECT
    SHORT_NAME "SDO_UNIT",
    UNIT_OF_MEAS_NAME "UNIT_NAME",
    (FACTOR_B/FACTOR_C) "CONVERSION_FACTOR"
  FROM
    MDSYS.SDO_UNITS_OF_MEASURE
  WHERE
    nls_lower(UNIT_OF_MEAS_TYPE)='length'

View Text - HTML Formatted

SELECT SHORT_NAME "SDO_UNIT"
, UNIT_OF_MEAS_NAME "UNIT_NAME"
, (FACTOR_B/FACTOR_C) "CONVERSION_FACTOR" FROM MDSYS.SDO_UNITS_OF_MEASURE WHERE NLS_LOWER(UNIT_OF_MEAS_TYPE)='LENGTH'