oracle 游标的高级用法

1.定义带有参数的游标

调用带有参数的游标，可以取得不同的查询结果集

 

 

cursor (v_dept number,v_job varchar2) is
   select last_name,salary,hire_date 
   from employees
   where department_id = v_dept
   and job_id = v_job;
...
  begin
  ....
   open emp_cursor(10,'java') 
   ... 
end;