plsql

DECLARE  
       CURSOR curEmp IS SELECT * FROM (SELECT * FROM emp ORDER BY sal DESC) e
       WHERE ROWNUM<6;
       emp_r curEmp%ROWTYPE;
  BEGIN
     OPEN curEmp;   
     FETCH curEmp INTO emp_r;
     WHILE(curEmp%FOUND)LOOP
     FETCH curEmp INTO emp_r;
     dbms_output.put_line('名字 '||emp_r.ename||' --薪水 '||emp_r.sal||
        ' ---工作 '||emp_r.job||'shijian'||to_char(emp_r.hiredate,'yy'));
     END LOOP;
     CLOSE curEmp;
  END;