pl/sql游标

image.png

declare
ie_id NUMBER(10);
ie_fn varchar2(20);
ie_ln varchar2(20);
ie_ge char(1);
cursor ie_cur is select ID,FIRST_NAME,LAST_NAME,GENDER from it_employees;
begin
open ie_cur;
fetch ie_cur into ie_id,ie_fn,ie_ln,ie_ge;
loop 
 exit when not ie_cur%found;
 if ie_ge='1' then insert into it_employees_m(id,first_name,last_name,gender) values(ie_id,ie_fn,ie_ln,ie_ge);
 else 
   insert into it_employees_f(id,first_name,last_name,gender) values(ie_id,ie_fn,ie_ln,ie_ge);
 end if;
 fetch ie_cur into ie_id,ie_fn,ie_ln,ie_ge;
 end loop;
 close ie_cur;
 end;