Re: download text file
From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Wed, 01 Sep 1999 08:21:38 -0400
Message-ID: <37CD1A52.68B495E2_at_Unforgettable.com>
from mytable;
exit success; Received on Wed Sep 01 1999 - 14:21:38 CEST
Date: Wed, 01 Sep 1999 08:21:38 -0400
Message-ID: <37CD1A52.68B495E2_at_Unforgettable.com>
"J. G. Dutcher" wrote:
> I'm looking for a way to down load data from our oracle database (i.e. the
> opposite of sqlload utilty), especially if I can do tab delimited text
> files. I've found no way to do it oracle utilities. Can anyone tell me of
> anything that works?
>
> JG Dutcher
> dutcherjg_at_navair.navy.mil
>
> TIA
just do something like this in sqlplus:
set pages 0;
set feedback off;
set termout off;
spool mydata.dat
select col1||','||
col2||','|| col3
from mytable;
exit success; Received on Wed Sep 01 1999 - 14:21:38 CEST