游标实例

CREATE OR REPLACE PROCEDURE merge_violationxdata_change IS
v_id varchar2(50);
  cursor metaSrc_cursor is select guid from v_bcwzxx;
begin
   open metaSrc_cursor;
   loop
     fetch metaSrc_cursor into v_id;
     exit when metaSrc_cursor%notfound;
      delete from TB_TRAFFIC_VIOLATION_XDATA@cyry where guid=v_id;  
    insert into TB_TRAFFIC_VIOLATION_XDATA@cyry(guid,AJAH,JCRQ,YHXKZH,YHMC,DSRXM,DSRSFZH,DSRZGZH,CPH,CPYS,HY,CFDX,WFSS,ZFJGMC,AJZT)
        select guid,AJAH,JCRQ,YHXKZH,YHMC,DSRXM,DSRSFZH,DSRZGZH,CPH,CPYS,HY,CFDX,WFSS,ZFJGMC,AJZT 
        from v_bcwzxx where  guid=v_id;
      commit;
   end loop;
close metaSrc_cursor;
check_date_kszx;
END merge_violationxdata_change;