Searched CASE expression test different conditions - PL/SQL

Q.  A searched CASE expression lets you test different conditions instead of comparing a single expression to various values.
- Published on 09 Jul 15

a. Yes
b. No

ANSWER: Yes
 
A searched CASE expression does not contain any selector. A search condition can also be found in each WHEN clause to determine a BOOLEAN value. Besides this, it also allows the testing of different variables or multiple conditions in a single WHEN clause.

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.)