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.

Post your comment / Share knowledge

Enter the code shown above:
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)