ORACLE中的游标集锦
ORACLE中的游标汇总游标（Cursor）：用来查询数据库，获取记录集合（结果集）的指针，可以让开发者一次访问一行结
ORACLE中的游标汇总
游标（Cursor）：用来查询数据库，获取记录集合（结果集）的指针，可以让开发者一次访问一行结果集，在每条结果集上作操作。
????游标可分为：
???
cursor emp_cur ( p_deptid in number) isset serveroutput ondeclareselect * from employees where department_id = p_deptid;
?
l_empdeclarebegin?update departments???游标FOR循环，简化游标操作my_dept_recDeclare??Cursordeclare?--声明记录类型?typeCREATE OR REPLACE PACKAGECREATE OR REPLACE PACKAGE BODYcreate or replace procedure open_cv(choiceCREATE or replace procedure retrieve_data(choice IN INT) is
emp_reccreate or replace procedure REF_BULK is
?typeDeclaretyperc?is ref cursor;cursor?c?is?select * from dual;
?
l_cursor?rc;beginif ( to_char(sysdate,'dd') = 30 ) then???????open?l_cursor?for?'select * from emp';elsif ( to_char(sysdate,'dd') = 29 ) then???????open?l_cursor?for?select * from dept;else???????open?l_cursor?for?select * from dual;end if;open c;end;/?
