Re: sql insert

From: Jérôme Texier <jtexier_at_ystel.fr>
Date: Tue, 6 Apr 1999 13:03:32 +0200
Message-ID: <7ecpmn$e06$1@jaydee.iway.fr>

Try :
Insert into devt_table select * from prod_table@<link>;

or you can use the COPY command.

---

Jérôme.
jt_at_ystel.fr

---

CY Chiam <cychiam_at_hq.psa.com.sg> a écrit dans le message : 3709da85.14204344_at_butler.psa...
> 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 - 06:03:32 CDT