Pl/sql case when multiple values

CASE Statement

The statement chooses from a sequence of conditions, and executes a corresponding statement. The statement evaluates a single expression and compares it against several potential values, or evaluates multiple Boolean expressions and chooses the first one that is .

Syntax

searched_case_statement ::=

[ <<label_name>> ] CASE { WHEN boolean_expression THEN {statement;} ...

}... [ ELSE {statement;}...

Oracle case when else

Oracle case when else

Nested case statement in oracle

Oracle case when in list

Oracle case when null

Oracle case when multiple conditions

] END CASE [ label_name ];

simple_case_statement ::=

[ <<label_name>> ] CASE case_operand { WHEN when_operand THEN {statement;} ... }... [ ELSE {statement;}...

] END CASE [ label_name ];

Keyword and Parameter Description

The value of the operand and operands in a simple statement can be any PL/SQL type other than , , an object type, a PL/SQL record, an index-by table, a varray, or a nested table.

If the clause is omitted, the system substitutes a default action.

For a statement, the default when none of the conditions matches is to raise a exception. For a expression, the default is to return .

Usage Notes

The cla

oracle case in join

oracle case in where clause example