使用存储过程再数据库中批量新建数据

create or replace procedure createtable_t_new1(start_num integer,step integer)
as
  i integer:=start_num;
begin
     loop
         i:=i+step;
         execute immediate 'create table a1'||to_char(lpad(i,10,'0'))|| ' AS SELECT * FROM example_table '; 
     exit when i>20*start_num;
         
     end loop;
end;

根据步长，使用存储过程批量建表

create or replace procedure createtable_t_new1(start_num integer,step integer)
as

begin
     loop

         for i in 1..10 loop
             insert into 'table_name'
                    select aa.nextval,'neusoft','softcompany' from dual; 
             
     end loop;
end;

使用序列作主键，添加记录