Re: Query results output

From: Tom Zamani <tomz_at_redflex.com.au>
Date: Wed, 15 Dec 1999 15:20:32 +1100
Message-ID: <8374op$68b$1@perki.connect.com.au>

create table myTBL (name varchar2(100),

                                id    number)

set pagesize 0
set feedback off
spool filename
select name'||','||id from mytbl
spool off

Tom

Ed Perry <eperryradian_at_my-deja.com> wrote in message news:8371u9$6p6$1_at_nnrp1.deja.com...
> 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.
Received on Tue Dec 14 1999 - 22:20:32 CST

Re: Query results output - URGENT