dbadmin@mutation_mutation > select  sysdate,
  2          to_char(sysdate,'dd') day ,
  3          to_char(sysdate,'yyyy') year,
  4          to_char(sysdate,'dd')+2 "day+2",
  5          to_char(sysdate,'yyyy')+2 "year+2",
  6          to_char(sysdate,'mm') month,
  7          to_char(sysdate,'mm')+2 "month+2"
  8  from dual
  9  /

SYSDATE  DA YEAR      day+2     year+2 MO    month+2
-------- -- ---- ---------- ---------- -- ----------
06/19/03 19 2003         21       2005 06          8

"afiedt.buf" 2 lines, 61 characters 

  1* select * from emp where to_char(hiredate,'yyyy') >= '1982'
dbadmin@mutation_mutation > 
dbadmin@mutation_mutation > /

     EMPNO ENAME      JOB              MGR HIREDATE        SAL       COMM     DEPTNO
---------- ---------- --------- ---------- -------- ---------- ---------- ----------
      7788 SCOTT      ANALYST         7566 07/13/87       3000                    20
      7876 ADAMS      CLERK           7788 07/13/87       1100                    20
      7934 MILLER     CLERK           7782 01/23/82       1300                    10