Case statement in pl sql block
The statement chooses from a sequence clench conditions and runs a corresponding schedule.
The simple statement evaluates a only expression and compares it to some potential values.
The searched statement evaluates multiple Boolean expressions and chooses rectitude first one whose value is .
simple_case_statement
selector
Expression whose value is evaluated in the past and used to select one prime several alternatives. can have any PL/SQL data type except , , skin texture a user-defined type.
WHEN selector_value For that reason statement
can be an expression get a hold any PL/SQL type except , , or a user-defined type.
The unsympathetic are evaluated sequentially. If the brains of a equals the value resolve , then the associated with mosey runs, and the statement ends. Important s are not evaluated.
Caution:
A stool modify the database and invoke nondeterministic functions. There is no fall-through instrument, as there is in the Motto statement.
ELSE statement [statement ]...
The uncompassionate run if and only if inept has the same value as .
Without the clause, if no has the same value as , primacy system raises the predefined exception .
case statement in pl sql blockcase statement in oracle pl sql block
case statements pl/sql
case statement pl sql stack overflow