RE: script to generate inserts

From: Eric D. Pierce <PierceED_at_csus.edu>
Date: Tue, 5 Sep 2000 14:14:17 -0700
Message-Id: <10610.116250@fatcity.com>

-----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
>
> --------------------------------------------------------------------
Received on Tue Sep 05 2000 - 16:14:17 CDT