SQL> select ename,hiredate,
2 to_char(next_day(add_months(hiredate,6),2),'fmdy ","fmddspth "of" fmmm ","rrrr') "Review" from emp;

ENAME HIREDATE Review
---------- -------------- ----------------------------------------
SMITH 17-12月-80 星期一 ,twenty-second of 6 ,1981
ALLEN 20-2月 -81 星期一 ,twenty-fourth of 8 ,1981
WARD 22-2月 -81 星期一 ,twenty-fourth of 8 ,1981
JONES 02-4月 -81 星期一 ,fifth of 10 ,1981
MARTIN 28-9月 -81 星期一 ,twenty-ninth of 3 ,1982
BLAKE 01-5月 -81 星期一 ,second of 11 ,1981
CLARK 09-6月 -81 星期一 ,fourteenth of 12 ,1981
SCOTT 19-4月 -87 星期一 ,twenty-sixth of 10 ,1987
KING 17-11月-81 星期一 ,twenty-fourth of 5 ,1982
TURNER 08-9月 -81 星期一 ,fifteenth of 3 ,1982
ADAMS 23-5月 -87 星期一 ,thirtieth of 11 ,1987

ENAME HIREDATE Review
---------- -------------- ----------------------------------------
JAMES 03-12月-81 星期一 ,seventh of 6 ,1982
FORD 03-12月-81 星期一 ,seventh of 6 ,1982
MILLER 23-1月 -82 星期一 ,twenty-sixth of 7 ,1982

已选择14行。

SQL> RUN
1 select job,decode(JOB,'CLERK','B',
2 'MANAGER','A',
3 'ANALYST','C',
4 'SALESMAN','E',
5 0) GRADE
6* FROM EMP

JOB GRADE
--------- -----
CLERK B
SALESMAN E
SALESMAN E
MANAGER A
SALESMAN E
MANAGER A
MANAGER A
ANALYST C
PRESIDENT 0
SALESMAN E
CLERK B

JOB GRADE
--------- -----
CLERK B
ANALYST C
CLERK B