Re: HELP (How to export a table to a delimetered text file)
From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Tue, 27 Apr 1999 09:36:25 -0400
Message-ID: <7g4ec8$1o1$1_at_autumn.news.rcn.net>
Seigmund Akinwande Johnson wrote in message ...
>Help ,
>Does anyone know how to do this ?
>
>
Received on Tue Apr 27 1999 - 15:36:25 CEST
Date: Tue, 27 Apr 1999 09:36:25 -0400
Message-ID: <7g4ec8$1o1$1_at_autumn.news.rcn.net>
Hi,
try this:
set pages 0
set echo off
set feedback off
set colsep '|'
spool <outputfile_name>
select * from <table_name>;
spool off
The key is the colsep character. Set it to anything you like.
regards
Jerry Gitomer
Seigmund Akinwande Johnson wrote in message ...
>Help ,
>Does anyone know how to do this ?
>
>
Received on Tue Apr 27 1999 - 15:36:25 CEST