469,934 Members | 2,019 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,934 developers. It's quick & easy.

Alias in Oracle Case function

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
0 4087

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

63 posts views Thread by Nick Palmer | last post: by
1 post views Thread by db2sysc | last post: by
1 post views Thread by Andrew Arace | last post: by
13 posts views Thread by Chris Botha | last post: by
4 posts views Thread by Pumkin | last post: by
3 posts views Thread by petermichaux | last post: by
9 posts views Thread by lnatz | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.