for c in代替insert select

----過程代碼(insert into比for c in效率高 )
create or replace procedure p_hkb_test is
begin
  begin
    insert into hkb_test1
      (USER_NAME, AGE, USER_ID)
      select a.user_name, a.age, a.user_id from hkb_test a;
  exception
    when others then
      rollback;
  end;
  commit;
  begin
    for c in (select a.user_name, a.age, a.user_id from hkb_test a) loop
      insert into hkb_test1 values (c.user_name, c.age, c.user_id);
    end loop;
  exception
    when others then
      rollback;
  end;
  commit;
end p_hkb_test;

--測試代碼
SQL> select * from hkb_test;
 
USER_NAME AGE USER_ID
--------- --- -------
a          12       1
b          12       2
b          15       3
c          15       4
c          16       5
d          16       5
f          16       5
 
7 rows selected
 
SQL> select * from hkb_test1;
 
USER_NAME AGE USER_ID
--------- --- -------
 
SQL> exec p_hkb_test;
 
PL/SQL procedure successfully completed
 
SQL> select * from hkb_test1;
 
USER_NAME AGE USER_ID
--------- --- -------
a          12       1
b          12       2
b          15       3
c          15       4
c          16       5
d          16       5
f          16       5
a          12       1
b          12       2
b          15       3
c          15       4
c          16       5
d          16       5
f          16       5
 
14 rows selected