Re: PL/SQL - Need copy table script

In SQL you could have

insert into table1
select * from table 2;

or in PL/SQL

declare

cursor t1 as
select * from table1;

begin
for trec in t1 loop

    insert into table2 values(trec.field1,trec.field2 ........); end loop;
end;

Hope this helps (in time)

Ian Received on Thu Oct 02 1997 - 00:00:00 CDT