Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: script to generate inserts
presumably you could easily modify Jared's "dump.sql" to give
the appropriate form of output:
insert into
target_table tt ( tt.column1, tt.column2, ... ) VALUES ( select st.column1, st.column2, ... from source_table st where ... );
On 5 Sep 2000, at 23:41, GKor_at_rdw.nl wrote:
Date sent: Tue, 05 Sep 2000 23:41:54 -0800 To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Send reply to: ORACLE-L_at_fatcity.com From: GKor_at_rdw.nl Subject: RE: script to generate inserts
> thats exactly what i ment. I'd like to append those records if that is
> possible.
>
> > -----Oorspronkelijk bericht-----
> > Van: David Barbour [SMTP:DBarbour_at_connectsouth.com]
> > Verzonden: 5-sep-00 23:06
> > Aan: Multiple recipients of list ORACLE-L
> > Onderwerp: RE: script to generate inserts
> >
> > Not clear what you are trying to accomplish.
> >
> > Are you trying to select values from one table to insert into another?
...
> > -----Original Message-----
> > Sent: Tuesday, September 05, 2000 10:26 AM
> > To: Multiple recipients of list ORACLE-L
...
> > Any one with a script to generate a insert script from a given table
> >
> >
Received on Wed Sep 06 2000 - 14:17:28 CDT
![]() |
![]() |