Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: script to generate inserts

RE: script to generate inserts

From: <GKor_at_rdw.nl>
Date: Wed, 6 Sep 2000 08:40:48 +0200
Message-Id: <10610.116275@fatcity.com>


thanks

> -----Oorspronkelijk bericht-----
> Van: Eric D. Pierce [SMTP:PierceED_at_csus.edu]
> Verzonden: 6-sep-00 00:17
> Aan: Multiple recipients of list ORACLE-L
> Onderwerp: RE: script to generate inserts
>
>
> -----fwd-----
>
> http://www.teleport.com/~jkstill/util/dump/dump.html
>
> Dump Oracle Tables To ASCII/Comma Delimited File
>
> dump.sql is a utility to dump a single table to a comma and double
> quote delimited file. In addition, SQL*LOADER control and parameter
> files will be generated as well.
>
> dump.sql will remove all double quotes from the data to avoid
> confusing
> SQL*LOADER. If you don't like this behavior, you may easily modify
> dump.sql to use a different delimiter, or skip using the quotes
> altogether.
>
> The use of the quotes however, makes it possible for commas to appear
> in the data without confusing SQL*LOADER.
>
>
> dump.sql in ASCII
>
> [ http://www.teleport.com/~jkstill/util/zips/dump.sql ]
>
>
> > -----Original Message-----
> > Sent: Tuesday, September 05, 2000 10:26 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > hi
> >
> > Any one with a script to generate a insert script from a given table
> >
> >
> >
> > insert into xxx values (' ',etc)
> >
> >
> > thanks
> > --
> > Author:
> > INET: GKor_at_rdw.nl
> >
> > --------------------------------------------------------------------
>
> --
> Author: Eric D. Pierce
> INET: PierceED_at_csus.edu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Sep 06 2000 - 01:40:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US