Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
IIF() like Function in Oracle?
Message
De
17/05/1999 16:26:17
 
 
À
17/05/1999 16:04:31
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00219769
Message ID:
00219777
Vues:
22
I think you can do what you want with a combination of DECODE and GREATEST.
Something like this maybe?

Select decode(greatest(num_trys, max_trys),num_trys, 'true', max_trys, 'false') from table

>Is there a function in Oracle that emulates what
>the VFP IIF() function does? The closest thing
>I have seen is the DECODE() function.
>
>What I need to do is as follows in a SQL passthru statement:
>
>IIF(num_trys > max_trys, 'True', 'False') AS fieldname
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform