ORACLE 批量插入-支持序列自增

-- Create table
create table test_batch
(
  id      number not null,
  name    varchar2(20),
  account varchar2(20)
)

-- Create sequence 
create sequence seq_test_batch
minvalue 1
maxvalue 9999999999999999999
start with 1
increment by 1
cache 20;

insert into test_batch(id, name, account)
select seq_test_batch.nextval, name, account from(
  select 'frank' as name , 'frank001' as account from dual
  union
  select 'quanbs' as name , 'quanbs001' as account from dual
);
commit;

select * from test_batch;