- 表中一次插入1条数据
insert into SE_D (no,num,urid,flowno,code,pay,account,name,amount,flag,detail)
values('BR195','QT001',102,'FN4030','103','101','1044','BJ',100,1,0)
- 表中一次插入多条数据
insert into SE_D (no,num,urid,flowno,code,pay,account,name,amount,flag,detail)
select 'BR195','QT001',102,'FN4030','103','101','1044','BJ',100,1,0 from dual
union
select 'BR195','QT001',102,'FN4030','103','101','1044','BJ',100,1,0 from dual
union
select 'BR195','QT001',102,'FN4030','103','101','1044','BJ',100,1,0 from dual
测试结果:
1. 使用语句1一次插入1条,总共插入1W条,执行完,耗时80s
2. 使用语句2一次插入100条,总共插入1W条,执行完,耗时9s