Using Searched CASE Expressions : CASE « Query Select « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Query Select
  3. CASE

Searched CASE expressions use conditions to determine the returned value and have the following syntax:

CASE
  WHEN condition1 THEN result1
  WHEN condition2 THEN result2
  ...
  WHEN conditionN THEN resultN
  ELSE default_result
END

where

  1. condition1, condition2, ..., conditionN are the expressions to be evaluated.
  2. result1, result2, ..., resultN are the returned results (one for each possible condition).
  3. If condition1 is true, result1 is returned, and so on.
  4. default_result is the default result returned when no true condition is found.




2.15.CASE
2.15.1.Using the CASE Expression
2.15.2.The following example illustrates the use of a simple CASE expression:
2.15.3.Using Searched CASE Expressions
2.15.4.The following example illustrates the use of a searched CASE expression:
2.15.5.Use logical operators in a searched CASE expression
2.15.6.Use CASE statement to deal with NULL
2.15.7.Use case when and grouping function together
2.15.8.Use case when clause to decode value
2.15.9.Use case when statement with between ... and
2.15.10.Use case when statement with exists and subquery
2.15.11.Use case when statement with in()
2.15.12.Use case when statement with to_char() like
2.15.13.Use case when with comparasion operator
2.15.14.Use Case to output null value
2.15.15.Wrap case when into sum() function