select ename,case when ename = 'SMITH' THEN 'SUPERMAN' when ename = 'ALLEN' THEN 'SUPERWOMAN' when ename = 'LEX' THEN 'GOD' else 'UNKNOW' end as "SHOW" from emp / ENAME SHOW ---------- ---------- SMITH SUPERMAN ALLEN SUPERWOMAN WARD UNKNOW JONES UNKNOW MARTIN UNKNOW BLAKE UNKNOW 1 select ename,case 2 when sal < 1500 3 then 'low' 4 when sal<=4000 and sal>=1500 5 then 'middle' 6 when sal<=5000 and sal>4000 7 then 'hight' 8 else 'unknow' 9 end as "pay level" 10* from emp ENAME pay le ---------- ------ SMITH low ALLEN middle WARD low JONES middle MARTIN low BLAKE middle CLARK middle SCOTT hight KING hight TURNER middle ADAMS low JAMES low FORD middle MILLER low