Sv: SQL to Dump rows to ASCII comma delimited File

From: Allan Saadbye <isl34485_at_image.dk>
Date: Wed, 28 Jul 1999 20:53:37 +0200
Message-ID: <GmIn3.335$d8.7724@news020.image.dk>

Hello Michael,

From the 'scott/tiger' you could make a selected field comma seperated file do this :

sql>spool filename.doc
sql>select ename||','||job
sql> from emp;

and spool off.
The file generated would be able to be imported in msoffice.

With regards Allan
michael laffety <mlaff_at_paragon.ie> skrev i en nyhedsmeddelelse:z3Dn3.850$Ua3.351_at_news.indigo.ie...
> Hi all,
>
> Does anyone have an SQL script that will dump select rows from a table to
a
> ASCII comma delimited File for subsequent processing by SQL loader.
Thanks
> in advance.
>
> Michael
>
>
Received on Wed Jul 28 1999 - 13:53:37 CDT