SELECT ROWID, SUB_INFORMATION_CATEGORY, SUB_INFORMATION1, SUB_INFORMATION2, SUB_INFORMATION3, SUB_INFORMATION1, (DECODE (SUB_INFORMATION_CATEGORY, 'DE', SUB_INFORMATION_CATEGORY || '.' || SUB_INFORMATION1 || '.' || SUB_INFORMATION2 || '.' || SUB_INFORMATION3, 'ZA', SUB_INFORMATION_CATEGORY || '.' || SUB_INFORMATION1, NULL)) FROM PER_SUBJECTS_TAKEN
SELECT ROWID
, SUB_INFORMATION_CATEGORY
, SUB_INFORMATION1
, SUB_INFORMATION2
, SUB_INFORMATION3
, SUB_INFORMATION1
, (DECODE (SUB_INFORMATION_CATEGORY
, 'DE'
, SUB_INFORMATION_CATEGORY || '.' || SUB_INFORMATION1 || '.' || SUB_INFORMATION2 || '.' || SUB_INFORMATION3
, 'ZA'
, SUB_INFORMATION_CATEGORY || '.' || SUB_INFORMATION1
, NULL))
FROM PER_SUBJECTS_TAKEN
|
|
|