select from emp where sysdate=add_months(hiredate,8;sql>eg
username os_username userhost client_id trunc(timestamp)
fromsales wheresale_date=trunc(sysdate-interval'1'day order
7fromdual6round(sysdate'y)5round(sysdate'yy,4round(sysdate
oracle中declare如何使用