467,136 Members | 1,414 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,136 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
  • viewed: 4025

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@yahoo.com | 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@gmail.com | 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.