Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: I can't believe I can't use IIF anymore!?!

Re: I can't believe I can't use IIF anymore!?!

From: K Stahl <BlueSax_at_Unforgettable.com>
Date: Thu, 24 Feb 2000 08:44:15 -0500
Message-ID: <38B535AF.B4BA5BA7@Unforgettable.com> 





Patrick Joyal wrote:


> 


> you know, like :


> 


> select IIF (Score >400, 'Congratulations!', 'Loser!') as Message ;


> 


> to my surprise, it doesn't work in Oracle





That is because we have a more powerful alternative called decode()
Received on Thu Feb 24 2000 - 07:44:15 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US