Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using a column alias in a sql select where clause.
Message
From
13/08/2002 08:36:11
 
 
General information
Forum:
Oracle
Category:
Reports
Miscellaneous
Thread ID:
00689055
Message ID:
00689059
Views:
24
I doubt whether oracle allow you to give alias with decode.
can't you use status in your where condition??
however if you want to achieve alias like functionality then try this
select order_id,
decode(status, 'Held', '1 - Held', 'Shipped', '2 - Shipped)
from order_header
where decode(status, 'Held', '1 - Held', 'Shipped', '2 - Shipped)= '1 - Held' 
Best Luck..
Nilesh
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform