測試了很久,網上說的方法很多,其實都是錯誤的,正確的寫法:
declare cursor rowAll is select * from tb_news where 1=1; row1 tb_news%rowtype; i int; begin i := 0; for row1 in rowAll loop row1.id := fn_gen_getid('tb_news'); row1.addtime := sysdate; row1.starttime := sysdate; row1.adduserid := -100; insert into tb_news values row1; commit; end loop; end;誤打誤撞,亂寫一通,沒想到這樣可以。不過我在查詢窗口使用dbms_output.put_line(sysdate); 怎麼都報錯,崩潰!by default7#zbphp.com