Also, set echo off (your script won't show in the file) and feedback off
(you won't get "n rows selected." message).
--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)
Jonathan Gennick <gennick_at_worldnet.att.net> wrote in article
<6o0enj$24d_at_bgtnsc03.worldnet.att.net>...
> On 8 Jul 1998 13:48:52 GMT, "John Farley"
> <JFarley_at_ionet.net> wrote:
>
> >I would appreciate any help on this probelm:
> >
> >How do you export an Oracle table into a fixed ascii fromat?
>
> One way is to use SQL*Plus. Do something like this:
>
> set heading off
> set pagesize off
>
> column xxx format a30
> column yyy format 999.99
>
> spool your_file.lis
> select xxx,yyy
> from zzz;
> spool off;
>
> Oh, if it's a large table, you might want to write a script
> for the above and include the SET TERMOUT OFF command in it.
> Spooling the output is much faster if you don't have to
> watch it go by on the screen.
>
> regards,
>
> Jonathan Gennick
Received on Wed Jul 08 1998 - 17:46:25 CDT
