DECLARE
    j     number;
    s_sql varchar2(5000);
  BEGIN
    FOR j IN 1 .. 1000000 LOOP
      s_sql := 'insert into collect_data
    select t.test_start_date,
           t.test_end_date,
           t.test_qq,
           t.test_name,
           DQMP_PROBLEM_DATA_SEQ.NEXTVAL,
           t.dept,
           t.password_old1,
           t.password_old2,
           t.password_modify_date
      from test1 t';
      execute immediate s_sql;
      commit;
    END LOOP;
  END;

————————————————
版权声明:本文为CSDN博主「czmchen」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/czmchen/article/details/6525133

标签: none

添加新评论