Re: Query results to csv file

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 09 Apr 2006 13:37:24 +0200
Message-ID: <odsh32duglauue75hsqbrdcc6cmmi2sii2@4ax.com>

On Sun, 9 Apr 2006 07:32:35 -0400, "Pat_RI" <pat2469_at_yahoo.com> wrote:

>I need to run a query and have the results published to a csv file. I am a
>relative newbie so any specific help would be much appreciated. The basic
>query below is what I want to export to a csv file.
>
>SELECT
> first,
> middle,
> last,
> soc_sec,
> add_1,
> add_2,
> city,
> state,
> zip,
> phone,
> emp_id
>FROM
> emp_info
>

On http://asktom.oracle.com you will find an utility you can simply feed a sql statement and it will dump it to csv.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sun Apr 09 2006 - 06:37:24 CDT