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;
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;