CASE vs. DECODE

by

There is one big difference between DECODE and CASE and it has to do with how NULLs are compared. DECODE will return “true” if you compare NULL to NULL. CASE will not. For example:

DECODE(NULL, NULL, 1, 0)

will return ‘1’.

CASE NULL
    WHEN NULL THEN 1
    ELSE 0
END

will return ‘0’. You would have to write it as:

CASE
    WHEN NULL IS NULL THEN 1
    ELSE 0
END

More Related Contents:

  1. SQL Query output in VBA is different than in SQL Oracle
  2. I want to find out how much zero come after 1 in SQL
  3. Splitting string into multiple rows in Oracle
  4. GROUP BY with MAX(DATE) [duplicate]
  5. Is there any function in oracle similar to group_concat in mysql? [duplicate]
  6. Can a foreign key be NULL and/or duplicate?
  7. Stored Procedure with optional “WHERE” parameters
  8. subquery in FROM must have an alias
  9. SQL multiple columns in IN clause
  10. SQL (ORACLE): ORDER BY and LIMIT [duplicate]
  11. How can I select from list of values in Oracle
  12. How to get second largest or third largest entry from a table [duplicate]
  13. Split String by delimiter position using oracle SQL
  14. How can I get the number of days between 2 dates in Oracle 11g? [duplicate]
  15. Update with Join query in Oracle
  16. Deferrable Constraints in SQL Server
  17. How to select records with maximum values in two columns?
  18. How do I get textual contents from BLOB in Oracle SQL
  19. Autoincrement in oracle to already created table
  20. SQL not displaying null values on a not equals query?
  21. What can cause an Oracle ROWID to change?
  22. How to add ‘ON DELETE CASCADE’ in ALTER TABLE statement
  23. Oracle query to match all values in the list among all rows in table
  24. adding primary key to sql view
  25. How do I call an Oracle stored procedure from an Excel VBA script?
  26. What does a (+) sign mean in an Oracle SQL WHERE clause? [duplicate]
  27. Connecting to Oracle Database using Sql Server Integration Services
  28. ORA-00933: SQL command not properly ended
  29. Update a table with data from another table
  30. Using bind variables with dynamic SELECT INTO clause in PL/SQL

Leave a Comment