I want to use below select query with if condition or decode, is it possible:SELECT 'ACTUAL' || '2013' AS DataSet, Company AS Facility, '99000004' AS Sub_Account, 'S' AS Account_Type, SUM((CR_Units_01 + DB_Units_01)/177.14) AS Month1,--I want to use the below line script if sysdate month is greater than 2 else '0' as month2, SUM((CR_Units_01 + DB_Units_01 + CR_Units_02 + DB_Units_02)/177.14) AS Month2,--I want to use the below line script if sysdate month is greater than 3 else '0' as month3, SUM((CR_Units_01 + DB_Units_01 + CR_Units_02 + DB_Units_02 + CR_Units_03 + DB_Units_03)/177.14) AS Month3,
I want to use this logic till month 12.Thank you very much for the helpful info.