Re: ASCII export

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: Sat, 14 Oct 2000 03:47:27 GMT
Message-ID: <20001014.3472700@mis.configured.host>

Try the following:

set linesize xxx where xxx is > linesize

set colsep ','

	spool <output file>
	select * from table;
	spool off


>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 10/13/00, 1:23:21 PM, craibuc_at_my-deja.com wrote regarding ASCII export:

> 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 th
e
> 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 - 22:47:27 CDT