SELECT ROWID, INFORMATION_CATEGORY, INFORMATION1, INFORMATION2, INFORMATION3, INFORMATION4, INFORMATION5, INFORMATION6, INFORMATION7,
(DECODE (INFORMATION_CATEGORY,
'GB_PQP_PENSERV_GRADE_INFO', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5 || '.' || INFORMATION6 || '.' || INFORMATION7, NULL))
FROM PER_GRADES
SELECT ROWID
, INFORMATION_CATEGORY
, INFORMATION1
, INFORMATION2
, INFORMATION3
, INFORMATION4
, INFORMATION5
, INFORMATION6
, INFORMATION7
,
(DECODE (INFORMATION_CATEGORY
,
'GB_PQP_PENSERV_GRADE_INFO'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5 || '.' || INFORMATION6 || '.' || INFORMATION7
, NULL))
FROM PER_GRADES
|
|
|