Re: Query results output - URGENT

SET colsep ','
SET pages 0
SET lines <nnn>
SET feedback OFF

SPOOL <file_name>.<ext>

SELECT * FROM <table_name>;

SPOOL OFF hth
jerry gitomer

Ed Perry wrote:

> I need to output the results of a query (executed in SQLPlus3.3 against
> Oracle7.3) to a comma-delimited text file. How can this be done? What
> is the easiest solution? The query returns about 15 fields of data for
> 25,000 records. I am at a client site tomorrow (Dec. 15) and need this
> for resolution. Thanks in advance to any/all respondants.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

--
Once I figured out how to spell DBA I became one Received on Tue Dec 14 1999 - 23:37:44 CST