利用游标插入表的sql语句

 
declare
 n_count integer := 0;
 
  cursor cur_bak is
    select ID,
           MAC,
           IP,
           NETBAR_ID,
           LOGIN_TIMES,
           LOGIN_DATE,
           GAME_ID,
           PROVINCE,
           CITY
      from SYS_LOGIN_RECORDS_DETAIL_BAK;

begin

  for i_cur_bak in cur_bak loop
    insert into SYS_LOGIN_RECORDS_DETAIL
      (ID,
       MAC,
       IP,
       NETBAR_ID,
       LOGIN_TIMES,
       LOGIN_DATE,
       GAME_ID,
       PROVINCE,
       CITY)
    values
      (i_cur_bak.id,
       i_cur_bak.MAC,
       i_cur_bak.IP,
       i_cur_bak.NETBAR_ID,
       i_cur_bak.LOGIN_TIMES,
       i_cur_bak.LOGIN_DATE,
       i_cur_bak.GAME_ID,
       i_cur_bak.PROVINCE,
       i_cur_bak.CITY);
 
    n_count := n_count + 1;
    if n_count >= 5000 then
      commit;
      n_count := 0;
    end if;
  end loop;
  commit;

end;
/