1:定义语法
cursor cursor_name(parame_name datatype) is select_statement;
2:示例
declare
cursor emp_cursor(no number) is select ename from emp where deptno = no;
v_ename emp.ename%type;
begin
open emp_cursor(10);
loop
fetch emp_cursor into v_ename;
exit when emp_cursor%notfound;
v_ename;
end loop;
close emp_cursor;
end;