Simple CASE expression selects result from one or more alternatives & returns result - PL/SQL
Q. In CASE Expressions, which expression selects a result from one or more alternatives, and returns the result?- Published on 09 Jul 15
a. Simple CASE Expression
b. Searched CASE Expression
c. Both A & B
d. None of the above
ANSWER: Simple CASE Expression
The CASE statement helps to select and execute one set of statements. It uses a selector rather than the multiple Boolean expression to select the sequence. An expression whose value will be used to select one of the several alternatives is known as an selector.