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