Simple SQL CASE example

View All Scripts Login to Run Script

Script Name Simple SQL CASE example
Description In this simple CASE expression, Oracle Database evaluates the first WHEN and returns the THEN if satisfied. It next considers the next WHEN condition. If none of the when conditions are met the ELSE is taken.
Area SQL General
Contributor Mike Hichwa (Oracle)
Created Tuesday February 23, 2016

Statement 1

select ename, case when sal >= 2900 then 'High' when sal > 1400 then 'Medium' else 'Low' end salary_scale
from scott.emp

 
ENAME SALARY_SCALE
KING High
BLAKE Medium
CLARK Medium
JONES High
SCOTT High
FORD High
SMITH Low
ALLEN Medium
WARD Low
MARTIN Low
TURNER Medium
ADAMS Low
JAMES Low
MILLER Low

14 rows selected.

ENAME	SALARY_SCALE
KING	High
BLAKE	Medium
CLARK	Medium
JONES	High
SCOTT	High
FORD	High
SMITH	Low
ALLEN	Medium
WARD	Low
MARTIN	Low
TURNER	Medium
ADAMS	Low
JAMES	Low
MILLER	Low

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database