Re: SQL Script to dump rows to ASCII File
From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Wed, 28 Jul 1999 11:08:15 -0400
Message-ID: <379F1CDF.D7CA4175_at_Unforgettable.com>
from mytable;
exit failure;
Date: Wed, 28 Jul 1999 11:08:15 -0400
Message-ID: <379F1CDF.D7CA4175_at_Unforgettable.com>
REM - Dump records to comma delimited file
set pages 0;
set lines 80;
set trimout on;
set trimspool on;
set feedback off;
set termout off;
spool data.dat
whenever sqlerror exit failure;
select col1||','||
col2||','||
col3||','||
col4
from mytable;
exit failure;
michael laffety wrote:
> Hi all,
>
> Does anyone have an SQL script that will dump select rows from a table to a
> ASCII comma delimited file without column headings for subsequent
> processing by SQL loader. Thanks
> in advance.
>
> Michael
Received on Wed Jul 28 1999 - 17:08:15 CEST