用这个?SET TRANSACTION USE ROLLBACK SEGMENT segment;insert into wl_course_tab values(1,'c') ; insert into wl_course_tab values(1,'c') ; insert into wl_course_tab values(1,'c') ;commit;
比如: insert into table(id, inc_datetime, random_id, random_string) select rownum as id, to_char(sysdate + rownum/24/3600,'yyyy-mm-dd hh24:mi:ss') as inc_datetime, trunc(dbms_random.value(0, 100)) as random_id, dbms_random.string('x', 20) random_string from dual connect by level <= 10;
insert into 表a(字段1,字段2) select 字段1,字段2 from 表b commit
如果数据从一个表插入另一个表可用
insert ... select.....
insert all ... select....或者如果要使用insert ... values ....通过循环插入
如果数据较多,可以多次提交,如每隔100条commt等
insert into wl_course_tab values(1,'c') ;
insert into wl_course_tab values(1,'c') ;commit;
insert into table(id, inc_datetime, random_id, random_string)
select rownum as id,
to_char(sysdate + rownum/24/3600,'yyyy-mm-dd hh24:mi:ss') as inc_datetime,
trunc(dbms_random.value(0, 100)) as random_id,
dbms_random.string('x', 20) random_string
from dual
connect by level <= 10;
insert into 表a(字段1,字段2) select 字段1,字段2 from 表b
commit