游标是一个查询结果集的定位器.
你可以在procedure这样定义游标,以下是我的例子
cursor c_on_line is
select barcode_no
from barcode_info where check_flag='S'
...
open c_on_line;
loop
fetch c_on_line into v_barcode_on_line;
exit when c2_on_line%notfound;
insert into history_barcode_info
select * from barcode_info
where barcode_no = v_barcode_on_line;
delete barcode_info where barcode_no = v_barcode_on_line;
commit;
end loop;
你可以在procedure这样定义游标,以下是我的例子
cursor c_on_line is
select barcode_no
from barcode_info where check_flag='S'
...
open c_on_line;
loop
fetch c_on_line into v_barcode_on_line;
exit when c2_on_line%notfound;
insert into history_barcode_info
select * from barcode_info
where barcode_no = v_barcode_on_line;
delete barcode_info where barcode_no = v_barcode_on_line;
commit;
end loop;
loop
fetch c_on_line into v_barcode_on_line;
exit when c_on_line%notfound;
insert into history_barcode_info
select * from barcode_info
where barcode_no = v_barcode_on_line;
delete barcode_info where barcode_no = v_barcode_on_line;
commit;
end loop;