SELECT ROWID, REG_INFORMATION_CONTEXT, (DECODE (REG_INFORMATION_CONTEXT, 'BR', REG_INFORMATION1, NULL)),
(DECODE (REG_INFORMATION_CONTEXT,
'BR', REG_INFORMATION_CONTEXT || '.' || REG_INFORMATION1, NULL))
FROM XLE_REGISTRATIONS
SELECT ROWID
, REG_INFORMATION_CONTEXT
, (DECODE (REG_INFORMATION_CONTEXT
, 'BR'
, REG_INFORMATION1
, NULL))
,
(DECODE (REG_INFORMATION_CONTEXT
,
'BR'
, REG_INFORMATION_CONTEXT || '.' || REG_INFORMATION1
, NULL))
FROM XLE_REGISTRATIONS
|
|
|