oracle 批量创建表

declare
tablecount number;
begin
tablecount:=1000;
while tablecount>0 loop

execute immediate 'create table riskset_'||tablecount||' as select * from riskset';
tablecount:=tablecount-1;
end loop;
end;