>What is the replacement of IIF() in ORACLE.
>
>
>Thannks in advance.

DECODE() is like an IIF() function. Ex.

select decode(mytable.fieldname,'A','Aardvark','B','Bandicoot')

Fieldname - expression to search for
'A' and 'B' - possible values of Fieldname
'Aardvark' and 'Bandicoot' - values to return of corresponding possible value is correct

Check out the documentation for more info on DECODE().

HTH.