摘要：
create or replace procedure 显示游标更新as--select taid, taname, bqid from table3new_taid number;cursor cur_table is --显示声明游标select taid from table3 where taid < 10for update of taid; --taid在<10的范围之内进行锁定 c_row cur_table%rowtype; --返回行的数据begin open cur_table; loop fetch cur_table into new_taid; exit 阅读全文
摘要：
create or replace procedure RefCursorastype toys_curtyp is ref cursor; cur toys_curtyp; stmt_str VARCHAR2(200); v_TAID number; v_taname VARCHAR2(100); v_bqid number;begin stmt_str :='select TAID, taname, bqid from table3'; OPEN cur FOR stmt_str; loop FETCH cur INTO v_TAID, v_taname,v_bqid; e 阅读全文
摘要：
create or replace procedure 隐式游标 as flag CHAR := 'U' ;beginif SQL%found then update table3 set TANAME='问问' where taid=1; commit; flag :='I'; insert into table3(taid,taname,bqid) values(4,'人事部',2); commit; end if; if flag ='U' then dbms_output.put_line('表已更 阅读全文
摘要：
create or replace procedure 带参数的游标as v_taid number(4); v_taname VARCHAR2(100); v_bqid number;CURSOR emp_cur(v_taname VARCHAR2) is --此处参数只是一个占位符而已SELECT taid, taname,bqid FROM table3 WHERE taid = v_taid;begin v_taid := 1; OPEN emp_cur(v_taname); LOOP FETCH emp_cur INTO v_taid, v_taname,v_bqid; EXIT W 阅读全文