Re: exporting to ASCII

From: <eiuepny_at_my-dejanews.com>
Date: Fri, 21 May 1999 21:46:41 GMT
Message-ID: <7i4k81$fcg$1@nnrp1.deja.com>

Would running the query from Excel and then saving as a CSV help?

In article <3742d89a.9076420_at_netnews.worldnet.att.net>, jonathan_at_gennick.com wrote:
> On Tue, 18 May 1999 14:38:22 -0500, Richard Spelling
> <richard_at_spellingbusiness.com> wrote:
>
> >IS there any way to do a database dump to some kind of delimited
ASCII
> >file?
>
> Short of writing your own program, the only convenient way
> that I've found is to use SQL*Plus to spool data to a file.
> I usually do something like this:
>
> set pagesize 0
> spool my_file.csv
>
> --Select some CSV data
> select '"' || cust_name || '",' || cust_no
> from cust_table;
>
> spool off
>
> The above should give you a file that looks like this:
>
> "Jonathan Gennick",101
> "Dave Leinen",102
> ...
>
> regards,
>
> Jonathan
>
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Fri May 21 1999 - 16:46:41 CDT