IIF equavalent function
444716May 27 2005 — edited Jun 10 2006HI,
I want a function which is replacing the iff function in SQL serever and Acces.
Eg:
Select iif(marks>80,'Distinction','Firstclass') from Gradesheet
This is sample query which will work in MS Access,SQL server etc. I want the replaing 'iif' command in oracle.
Offcourse Oracle have a function DECODE. but by using that we cannot verify an expression.
Is there any other function in oracle which returns user defined output based on expression.
With Thanks & rgds
Aji