批量插入使用 Sequence

create or replace function get_seq (p_in_sqname in varchar2) return number
is
  l_res number ;
begin
  execute immediate 'select '|| p_in_sqname|| '.nextval from dual' into l_res ;
  return l_res ;
end;

insert into exceltable  (id,chinese,english) 
  select get_seq('excel_seq'),'111','111' from dual union all 
  select get_seq('excel_seq'),'222','222' from dual;

参考资料

• https://blog.csdn.net/u013036792/article/details/48497571