CASE STATEMENT in Oracle

`CASE` expressions in oracle is similar to IF ... THEN ... ELSE logic in SQL statements.
Evaluated in Top to bottom approach, If a condition is true, then corresponding THEN clause is executed and execution jumps to the END CASE clause.

syntax:
```
CASE [ expression ]
WHEN condition_1 THEN result_1
WHEN condition_2 THEN result_2
...
WHEN condition_n THEN result_n
ELSE result
END
```
Example:
```
SELECT emp_name, emp_no, dept_no
(CASE dept_no
WHEN 10 THEN 'ACCOUNTS'
WHEN 20 THEN 'HR'
WHEN 30 THEN 'OPERATIONS'
WHEN 40 THEN 'SALES'
ELSE 'UNKNOWN'
END) DEPARTMENT
FROM EMPLOYEE
ORDER BY emp_name;
```