Re: copy data from one table to another

Hi dear ,
You can try my version also.
A table test with two fields as
Test(id number(3),desc long) and you want to copy it to another table test1, here is the script,
declare
  cursor c1 is select * from test;
begin
  for c1rec in c1 loop
   insert into test1 values( c1rec.id,c1rec.desc);   exit when c1%notfound;
  end loop;
end;

This will solve your problem.
Regards
Devinder Received on Thu Aug 13 1998 - 13:18:25 CDT