ORACLE IIF Statement

by

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

More Related Contents:

  1. Calculate difference between 2 date / times in Oracle SQL
  2. Can you SELECT everything, but 1 or 2 fields, without writer’s cramp?
  3. How to generate entire DDL of an Oracle schema (scriptable)?
  4. How to handle Day Light Saving in Oracle database
  5. How to get records randomly from the oracle database?
  6. Oracle PL/SQL – Raise User-Defined Exception With Custom SQLERRM
  7. Auto Increment for Oracle
  8. Get resultset from oracle stored procedure
  9. Deploying and Configuring ODP.NET to work without installation with Entity Framework
  10. Add a auto increment primary key to existing table in oracle [duplicate]
  11. ways to avoid global temp tables in oracle
  12. Spring Batch ORA-08177: can’t serialize access for this transaction when running single job, SERIALIZED isolation level
  13. How to generate an entity-relationship (ER) diagram using Oracle SQL Developer
  14. Number of rows affected by an UPDATE in PL/SQL
  15. String to date in Oracle with milliseconds
  16. Error while trying to retrieve text for error ORA-01804
  17. Create Pivot view in SQL from a SQL table
  18. Spool Command: Do not output SQL statement to file
  19. URL string format for connecting to Oracle database with JDBC
  20. Is there any way to have the JBoss connection pool reconnect to Oracle when connections go bad?
  21. Get ID of last inserted record in oracle db
  22. oracle SQL plus how to end command in SQL file?
  23. Why is the GETDATE() an invalid identifier
  24. Get the number of days between two dates in Oracle, inclusive of the dates
  25. ORA-04091: table [blah] is mutating, trigger/function may not see it
  26. How to use parameters in a ‘where value in…’ clause?
  27. How to convert “1985-02-07T00:00:00.000Z” (ISO8601) to a date value in Oracle?
  28. How to generate a version 4 (random) UUID on Oracle?
  29. Oracle SQL Developer: Show REFCURSOR Results in Grid?
  30. Find out the history of SQL queries

Leave a Comment