SELECT ROWID, CAG_INFORMATION_CATEGORY, (DECODE (CAG_INFORMATION_CATEGORY, 'NL', CAG_INFORMATION1, 'FR', CAG_INFORMATION1, NULL)),
(DECODE (CAG_INFORMATION_CATEGORY,
'FR', CAG_INFORMATION_CATEGORY || '.' || CAG_INFORMATION1,
'NL', CAG_INFORMATION_CATEGORY || '.' || CAG_INFORMATION1, NULL))
FROM PER_COLLECTIVE_AGREEMENTS
SELECT ROWID
, CAG_INFORMATION_CATEGORY
, (DECODE (CAG_INFORMATION_CATEGORY
, 'NL'
, CAG_INFORMATION1
, 'FR'
, CAG_INFORMATION1
, NULL))
,
(DECODE (CAG_INFORMATION_CATEGORY
,
'FR'
, CAG_INFORMATION_CATEGORY || '.' || CAG_INFORMATION1
,
'NL'
, CAG_INFORMATION_CATEGORY || '.' || CAG_INFORMATION1
, NULL))
FROM PER_COLLECTIVE_AGREEMENTS
|
|
|