ORACLE IIF Statement

Question

I get an error while writing the IIF statement  table and the statement given below  Statement  SELECT IIF EMP ID 1  True   False   from Employee   Table  CREATE TABLE SCOTT EMPLOYEE      EMP ID       INTEGER                          NOT NULL     EMP FNAME    VARCHAR2 30 BYTE                 NOT NULL     EMP LNAME    VARCHAR2 30 BYTE                 NOT NULL     EMP ADDRESS  VARCHAR2 50 BYTE                 NOT NULL     EMP PHONE    CHAR 10 BYTE                     NOT NULL     EMP GENDER   CHAR 1 BYTE     Error   00907-missing right parantheses  Please provide your inputs

User · Answer

In PL SQL  there is a trick to use the undocumented OWA UTIL ITE function    SET SERVEROUTPUT ON  DECLARE     x   VARCHAR2 10   BEGIN     x    owa util ite  a     b   T   F        dbms output put line x   END     F  PL SQL procedure successfully completed

User · Answer

Oracle doesn t provide such IIF Function   Instead  try using one of the following alternatives   DECODE Function   SELECT DECODE EMP ID  1   True    False   from Employee   CASE Function   SELECT CASE WHEN EMP ID   1 THEN  True  ELSE  False  END from Employee

User · Answer

Two other alternatives    a combination of NULLIF and NVL2  You can only use this if emp id is NOT NULL  which it is in your case   select nvl2 nullif emp id 1   False   True   from employee   simple CASE expression  Mt  Schneiders used a so-called searched CASE expression   select case emp id when 1 then  True  else  False  end from employee

[oracle] ORACLE IIF Statement

Examples related to oracle

Examples related to conditional-operator

Examples related to iif