SELECT ROWID, INFORMATION_CATEGORY, TP_COST_INFORMATION1, TP_COST_INFORMATION2, (DECODE (INFORMATION_CATEGORY, 'FR_FR_ACTUAL_HOURS', INFORMATION_CATEGORY || '.' || TP_COST_INFORMATION1 || '.' || TP_COST_INFORMATION2, NULL)) FROM OTA_TRAINING_PLAN_COSTS
SELECT ROWID
, INFORMATION_CATEGORY
, TP_COST_INFORMATION1
, TP_COST_INFORMATION2
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_ACTUAL_HOURS'
, INFORMATION_CATEGORY || '.' || TP_COST_INFORMATION1 || '.' || TP_COST_INFORMATION2
, NULL))
FROM OTA_TRAINING_PLAN_COSTS
|
|
|