SELECT ROWID, EST_INFORMATION_CATEGORY, (DECODE (EST_INFORMATION_CATEGORY, 'NO', EST_INFORMATION1, 'DK', EST_INFORMATION1, NULL)),
(DECODE (EST_INFORMATION_CATEGORY,
'DK', EST_INFORMATION_CATEGORY || '.' || EST_INFORMATION1,
'NO', EST_INFORMATION_CATEGORY || '.' || EST_INFORMATION1, NULL))
FROM PER_ESTABLISHMENTS
SELECT ROWID
, EST_INFORMATION_CATEGORY
, (DECODE (EST_INFORMATION_CATEGORY
, 'NO'
, EST_INFORMATION1
, 'DK'
, EST_INFORMATION1
, NULL))
,
(DECODE (EST_INFORMATION_CATEGORY
,
'DK'
, EST_INFORMATION_CATEGORY || '.' || EST_INFORMATION1
,
'NO'
, EST_INFORMATION_CATEGORY || '.' || EST_INFORMATION1
, NULL))
FROM PER_ESTABLISHMENTS
|
|
|