select decode(deptno, 10, 'class1', 20, 'class2', 30, 'class3') trclass , ename, job, sal, comm from emp
| NAME | JOB | SAL | COMM |
|---|
| DUDE |
DUDES |
-350 |
500 |
| - |
DUDES |
1250 |
520 |
| KING |
PRESIDENT |
5000 |
- |
| BLAKE |
MANAGER |
2850 |
- |
| CLARK |
MANAGER |
2450 |
- |
| JONES |
MANAGER |
2975 |
- |
| SCOTT |
ANALYST |
3000 |
- |
| FORD |
ANALYST |
3000 |
- |
| SMITH |
CLERK |
800 |
- |
| ALLEN |
SALESMAN |
1600 |
300 |
| WARD |
SALESMAN |
1250 |
500 |
| MARTIN |
SALESMAN |
1250 |
1400 |
| TURNER |
SALESMAN |
1500 |
0 |
| ADAMS |
CLERK |
1100 |
- |
| JAMES |
CLERK |
950 |
- |
|