Oracle Óαê Cursor ʹÓÃ

create or replace procedure getok
as
cursor mycur is select ids,name from aaa where name not in (select names from ok);
vempno aaa.ids%type;
vename aaa.name%type;
begin
open mycur;
loop
fetch mycur into vempno,vename;
exit when mycur%notfound;
if mycur%found then
    insert into ok values(vempno,vename);
end if;
end loop;
dbms_output.put_line('I Found You!'||mycur%rowcount||'ÐÐ');
close mycur;
end getok;
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/lixianzhang0493/archive/2009/12/31/5109682.aspx