DBA Data[Home] [Help]

VIEW: MDSYS.SDO_AREA_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)='area'
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)='AREA'