oracle 批处理脚本

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;