SELECT ROWID, INFORMATION_CATEGORY, INFORMATION1, INFORMATION2, INFORMATION3,
(DECODE (INFORMATION_CATEGORY,
'FR_PQH', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3, NULL))
FROM PQH_ROLES
SELECT ROWID
, INFORMATION_CATEGORY
, INFORMATION1
, INFORMATION2
, INFORMATION3
,
(DECODE (INFORMATION_CATEGORY
,
'FR_PQH'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3
, NULL))
FROM PQH_ROLES
|
|
|