SELECT ROWID, PGI_INFORMATION_CATEGORY, PGI_INFORMATION1, PGI_INFORMATION2, PGI_INFORMATION3, PGI_INFORMATION1, PGI_INFORMATION2, PGI_INFORMATION3, PGI_INFORMATION4, PGI_INFORMATION5,
(DECODE (PGI_INFORMATION_CATEGORY,
'PQH_FR_CORP_INFO', PGI_INFORMATION_CATEGORY || '.' || PGI_INFORMATION1 || '.' || PGI_INFORMATION2 || '.' || PGI_INFORMATION3,
'PQH_GSP_EXTRA_INFO', PGI_INFORMATION_CATEGORY || '.' || PGI_INFORMATION1 || '.' || PGI_INFORMATION2 || '.' || PGI_INFORMATION3 || '.' || PGI_INFORMATION4 || '.' || PGI_INFORMATION5, NULL))
FROM BEN_PGM_EXTRA_INFO
SELECT ROWID
, PGI_INFORMATION_CATEGORY
, PGI_INFORMATION1
, PGI_INFORMATION2
, PGI_INFORMATION3
, PGI_INFORMATION1
, PGI_INFORMATION2
, PGI_INFORMATION3
, PGI_INFORMATION4
, PGI_INFORMATION5
,
(DECODE (PGI_INFORMATION_CATEGORY
,
'PQH_FR_CORP_INFO'
, PGI_INFORMATION_CATEGORY || '.' || PGI_INFORMATION1 || '.' || PGI_INFORMATION2 || '.' || PGI_INFORMATION3
,
'PQH_GSP_EXTRA_INFO'
, PGI_INFORMATION_CATEGORY || '.' || PGI_INFORMATION1 || '.' || PGI_INFORMATION2 || '.' || PGI_INFORMATION3 || '.' || PGI_INFORMATION4 || '.' || PGI_INFORMATION5
, NULL))
FROM BEN_PGM_EXTRA_INFO
|
|
|