Pl/sql case when multiple conditions

simple_case_expression::=

searched_case_expression::=

In a simple expression, Oracle Database searches for the first ... pair for which is equal to and returns .

If none of the ... pairs meet this condition, and an clause exists, then Oracle returns . Otherwise, Oracle returns null.

In a searched expression, Oracle searches from left to right until it finds an occurrence of that is true, and then returns .

If no is found to be true, and an clause exists, then Oracle returns . Otherwise, Oracle returns null.

Oracle case

Oracle Database uses short-circuit evaluation. For a simple expression, the database evaluates each value only before comparing it to , rather than evaluating all values before comparing any of them with . Consequently, Oracle never evaluates a if a previous is equal to .

For a searched expression, the database evaluates each to determine whether it is true, and never evaluates a if the previous was true.

For a simple expression, the and all values must either have the same data type (, , , or , , , or ) or must all have a numeric data type.

If all expressions hav

case within a case oracle sql