Re: ASCII export

From: Stefan Grundmann <s.grundmann_at_t-online.de>
Date: Fri, 13 Oct 2000 22:58:34 +0100
Message-ID: <8s7t8l$1hl$04$1@news.t-online.com>

Hallo Craig!

Have you tried to set the length of lines in SQL*Plus to an appropriate value?
SQL> set lin 1000

Hope this help's,
Stefan.

<craibuc_at_my-deja.com> schrieb in im Newsbeitrag: 8s7gho$uea$1_at_nnrp1.deja.com...
> What is the easiest way to export 50 Oracle 7.x tables to 50 separate
> ASCII files? I need to the files to be comma-delimited and include the
> full column names. I've tried Toad and DBArtisan, but they have
> limitations. I've tried SPOOL in SQL*Plus, but the columns wrap. Any
> ideas?
>
> Thanks,
>
> Craig B.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Oct 13 2000 - 16:58:34 CDT