SELECT ROWID, INFORMATION_CATEGORY, (DECODE (INFORMATION_CATEGORY, 'QUICK_HIRE', INFORMATION1, 'PERWSQHM', INFORMATION1, NULL)),
(DECODE (INFORMATION_CATEGORY,
'PERWSQHM', INFORMATION_CATEGORY || '.' || INFORMATION1,
'QUICK_HIRE', INFORMATION_CATEGORY || '.' || INFORMATION1, NULL))
FROM HR_ITEM_PROPERTIES_B
SELECT ROWID
, INFORMATION_CATEGORY
, (DECODE (INFORMATION_CATEGORY
, 'QUICK_HIRE'
, INFORMATION1
, 'PERWSQHM'
, INFORMATION1
, NULL))
,
(DECODE (INFORMATION_CATEGORY
,
'PERWSQHM'
, INFORMATION_CATEGORY || '.' || INFORMATION1
,
'QUICK_HIRE'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, NULL))
FROM HR_ITEM_PROPERTIES_B
|
|
|