1. 批量建表
declare
tablecount number;
begin
tablecount:=3000;
while tablecount>0 loop
execute immediate 'create table table_'||tablecount||' (ID NUMBER(10), NAME VARCHAR(20))';
tablecount:=tablecount-1;
end loop;
end;
1. 批量建表
declare
tablecount number;
begin
tablecount:=3000;
while tablecount>0 loop
execute immediate 'create table table_'||tablecount||' (ID NUMBER(10), NAME VARCHAR(20))';
tablecount:=tablecount-1;
end loop;
end;