Re: SQL to Dump rows to ASCII comma delimited File

SET COLSEP ','
SPOOL filename
SELECT * FROM table;
SPOOL OFF
SET COLSEP ' ' michael laffety wrote in message ...
>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 - 08:41:16 CDT