Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IIF equavalent function

444716May 27 2005 — edited Jun 10 2006
HI,

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 8 2006
Added on May 27 2005
5 comments
514 views