What is the use of CASE in Oracle?

Answer 1

CASE expression is used like IF..THEN...ELSE logic in SQL statement without invoking procedures.
Example:
SELECT ename,
sal,
CASE sal WHEN 1000 THEN 'Low'
WHEN 5000 THEN 'High'
ELSE 'Medium'
END
FROM emp;