DECLARE
  TYPE emp_cursor_type IS REF CURSOR; --聲明游標類型
   emp_cursor emp_cursor_type; --聲明游標變量
  emp_record employee%ROWTYPE;
BEGIN
  OPEN emp_cursor FOR SELECT * FROM employee
  WHERE  departmentno='008'; --打開游標變量
  LOOP
   FETCH emp_cursor INTO emp_record;--提取數據
   EXIT WHEN emp_cursor%NOTFOUND;
   dbms_output.put_line('員工名：'||emp_record.employeename);
   END LOOP;
  CLOSE emp_cursor;--關閉游標變量
END;