Does PL/SQL support IIF function?

[mpsTiffany]

I need to create a pivot select statement. The best way I know how is to use IIF function but it's keep telling me that the right ) is missing. Does PL/SQL support this function?

 

[CTzen]

If you are looking for IIF() as in SQL Server, you have to use DECODE() or CASE instead.

They both have their pluses and minuses, choose one that works better for this particular task.

 

[Stew Stryker]

Personally, I prefer the CASE clause to DECODE(), but maybe that's just me!

 

[orca777]

Personally, I prefer the CASE clause to DECODE(),

me too
Karl

 

[CTzen]

@Stew Stryker
@orca777

ok, ok, I added CASE as another option

 

[Stew Stryker]

LOL

A little peer pressure and you fold like a chair!