Alias in Oracle Case function

Prakash_Joy

I wanted to have a query in which i have to have an alias name in the case condition as follows :

select r.column1 as Name1,t.Column2 as Name2,

case @Month when 2 then t.Column1 as Jan when 3 then t.Column3 as Feb ... end

from table1 t ,table2 r


But it is giving syntax error for the same
.can anyone help me out on this case

Jan 2 '07 #1