MySQL中支持一条SQL语句执行批量插入,Oracle中支持的形式有些不同,但是殊途同归,用的就是insert all into语法。...但insert all into中子查询不支持使用序列,如下操作,提示错误,
SQL> insert all
2 into a1(id, a, b, c, d) values (seq_a1....nextval, 'a', 'a', 'a', 'a')
3 into a1(id, a, b, c, d) values (seq_a1.nextval, 'b', 'b', 'b',...'b')
4 select seq_a1.nextval, a, b, c, d from a1;
select seq_a1.nextval, a, b, c, d from a1..., 'a', 'a', 'a', 'a')
3 into a1(id, a, b, c, d) values (seq_a1.nextval, 'b', 'b', 'b', 'b')