SELECT ROWID, ATTRIBUTE_CATEGORY, (DECODE (ATTRIBUTE_CATEGORY, 'BUILDING', ATTRIBUTE_CATEGORY, 'FLOOR', ATTRIBUTE_CATEGORY, 'LAND', ATTRIBUTE_CATEGORY, 'OFFICE', ATTRIBUTE_CATEGORY, 'PARCEL', ATTRIBUTE_CATEGORY, 'SECTION', ATTRIBUTE_CATEGORY, NULL)) FROM PN_LOCATIONS_ALL
SELECT ROWID
, ATTRIBUTE_CATEGORY
, (DECODE (ATTRIBUTE_CATEGORY
, 'BUILDING'
, ATTRIBUTE_CATEGORY
, 'FLOOR'
, ATTRIBUTE_CATEGORY
, 'LAND'
, ATTRIBUTE_CATEGORY
, 'OFFICE'
, ATTRIBUTE_CATEGORY
, 'PARCEL'
, ATTRIBUTE_CATEGORY
, 'SECTION'
, ATTRIBUTE_CATEGORY
, NULL))
FROM PN_LOCATIONS_ALL
|
|
|