Oracle批量保存的两种方法

Oracle批量保存的两种方法

创建序列： create sequence dept_seq minvalue 0;

方法1：

  begin
         insert into dept(deptno,dname,loc) values (dept_seq.nextval,'111','AAA');
        insert into dept(deptno,dname,loc) values (dept_seq.nextval,'222','BBB');
  end;
 
方法2：

  insert into dept(deptno,dname,loc)
         select dept_seq.nextval,dname,loc from(
                select '333' dname ,'CCC' loc from dual
                union
                 select '444' dname,'DDD' loc from dual
                  union
                 select '555' dname,'EEE' loc from dual
         )