sql insert

I am trying to copy some records from the Production server to Development server through the use of db link, say <link>.

The stored procedure I have in mind is as follows:

-----------start-------

create procedure procGetLiveData
cursor dataCursor is
  select * from prod_table@<link> where <key> = <value>;

begin
  for c in dataCursor
  loop
    insert into devt_table

  end loop;
end procGetLiveData;
----------end--------

prod_table and devt_table have the same schema. The schema is very long. Is there a simplified way to insert into devt_table without stating the fields of the table?

Thanks. Received on Tue Apr 06 1999 - 04:57:33 CDT