Re: Creating delimited output in a file

From: Anthony Hogan <anon_at_spain.es>
Date: Fri, 19 Oct 2001 13:43:43 +0100
Message-ID: <3BD01FFF.8C4192AA@spain.es>

Hi Noah,
Use spool from a sqlplus session.

SQL> set hea off;
SQL> spool c:\dba\test.csv;
SQL> select col1 || ',' || col2 || ',' || etc..

  2 from table;
SQL> spool off;

You will need to clean the top & end lines of the csv

hth
Anthony Hogan
hogananthony_at_hotmail.com

Noah Arc wrote:
>
> Is there any way of creating delimited output in a file
> on the client's PC from the server? I can create CSVs
> using, say, Reports, but am unsure of a way of
> transferring the file from the server to the client
> (across OSes).
>
> We have Oracle Apps, so can't use anything
> client-based, such as Access or Excel; that'd be
> too easy! I'm looking for a server-based solution
> (which I'm currently doubtful that there is).
>
> Thanks for any thoughts.
> --
> Noah Arc
> Remove ".spam.begone"
Received on Fri Oct 19 2001 - 07:43:43 CDT