[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'