begin
for i in 2..100 loop
execute immediate('create table table'||i||' as
select * from table1');
end loop;
end;
for i in 2..100 loop
execute immediate('create table table'||i||' as
select * from table1');
end loop;
end;
spool c:\ctable.sql
select 'create table table'||rownum+1||' as select * from table1;' from all_objects
where rownum<100;
spool off;
@c:\ctable.sql