Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using a column alias in a sql select where clause.
Message
De
13/08/2002 08:36:11
 
 
À
13/08/2002 08:09:20
Information générale
Forum:
Oracle
Catégorie:
Rapports
Divers
Thread ID:
00689055
Message ID:
00689059
Vues:
23
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform