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 -> IIF IN ORACLE

IIF IN ORACLE

From: Eitan <nospam_at_nospam_please.com>
Date: Mon, 8 May 2006 18:16:35 +0200
Message-ID: <445f5c86@news.bezeqint.net>


In sql-server (or access) there is a db-function : IIF. i.e.
IIF(A=B, <RESULT WHEN TRUE>, <RESULT WHEN FALSE>);

(It should be in a select statemant !!!)

What is the equivalent in Oracle 9i.
(not decode, because decode is one value, like case statement,
I want to ask something like :
if a between 1..20 then
  <when true>
else
  <when false>
end if; Received on Mon May 08 2006 - 11:16:35 CDT

Original text of this message

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