存储过程

create or replace procedure pro_test_cursor is
cursor userRows is
select * from I_SKYEMPLOYEE@mthhr ise where ise.modified = '2' ;
begin
for userRow in userRows loop
update skyemployee se
set se.compid = userRow.compid ,
se.depid = userRow.depid ,
se.jobid = userRow.jobid ,
se.compidcname = userRow.compidcname ,
se.depidcname = userRow.depidcname ,
se.jobidcname = userRow.jobidcname ,
se. modified = userRow.Modified
where se.badge=userRow.badge;
end loop;
end;


n.doccreatedate>To_Char(Add_Months(Sysdate, -1), 'yyyy-mm-dd')