Re: Exporting data to ASCII .CTL and .SQL

rzx2122_at_mcvax2.d48.lilly.com wrote:
> Reply-To: 72072.2122_at_compuserve.com
> Sender: 72072.2122_at_compuserve.com
 

> ========================================================================
> ====================
> Utilities for Oracle
> ====================
 

> Submitted by Joe Harleman
> Applied Database Design, Inc.
> Pensacola, Fl 32514
> 904-479-3416
 

> Placed in the public domain 10-JUN-92 without restriction.
 

> --------------------------------------------------------------------------------
> - this utility will not work properly if the table as embedded characters
> recognized by SQL*Plus (e.g. single quotes, ampersands)

Nor will it work if your table includes LONG columns: see the lines in the script which place TO_CHAR( ) around the columns, and treat LONG in the same manner as DATE and CHAR, or alternatively, don't export them at all.

Otherwise, I'm impressed. Very nice.

--
  _________________________   __________________________________________
 /  Tommy Wareing          \ /  In the beginning, there was The Bomb    \
|  p0070621_at_uk.ac.brookes   X   And The Bomb said "Let there be Light!"  |
 \  0865-483389            / \     - The Bomb, Dark Star                /
  ~~~~~~~~~~~~~~~~~~~~~~~~~   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~