if-elseif-else 'condition' in oracle SQL

Question

I am wondering if there if possibility to achieve some thing like 'if-elseif-else' condition , i know there is a 'case-when-then-else' but it checks only one condition at a time (if i understand it correctly). How can i achieve if-elseif-else scenario in Oracle sql

Accepted Answer

You can use if/else using case statements like this.

```
SELECT ename, CASE WHEN sal = 1000 THEN 'Minimum wage'
                   WHEN sal > 1000 THEN 'Over paid'
                   ELSE 'Under paid'
              END AS "Salary Status"
FROM   emp;
```

if-elseif-else 'condition' in oracle SQL

Solution

Problem

Related problems