April 24th, 2009, 04:01 AM
Join Date: Apr 2009
Time spent in forums: 1 h 11 m 20 sec
Reputation Power: 0
Please help me to solve error ORA-00904
I have a input p_groupmonths if p_groupmonths=1 then some value will display else 0.
below is the code
decode(:p_groupmonths,'1',to_number(to_char(rptfro m,'MM')),0) perSl,
instead of input valriable i want to show both 1 and 0 and if 1 then some value else 0
for the same my query is below:
(select 1 aoi from dual union all select 0 from dual) ,
end as aoi,
But I a getting error. ORA-00904: "AOI": invalid identifier
Can anybody help me to solve this?
Thanks and Regards