Re: ASCII export

From: Helen Jian <helenjian_at_idirect.com>
Date: Sat, 14 Oct 2000 00:53:50 GMT
Message-ID: <y8OF5.1902$Rg6.5518@quark.idirect.com>

Hi,

If you have Microsoft Excel installed, try 'Get External Data' from Oracle using ODBC. The query will pull out all column names and table data.

<craibuc_at_my-deja.com> wrote in message news: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 - 19:53:50 CDT