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