Re: Exporting to flat text ????

In article <85l6h5$bth$1_at_nnrp1.deja.com>,   Coolc <clarencehj_at_yahoo.com> wrote:
> How do you export a oracle tabel to a flat comma delimited file?
>
> Clarence
>

You can use the sqlplus spool command along with the set options to create text files.
set pagesize 0 << suppress headings
set linesize 133 << make lines long enough for row to fit select col1,||','||col2,||','||colN
from table_in_ques
where ....

Otherwise you can look into the utl_file package or write a pro*c program.

--
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jan 13 2000 - 13:32:53 CST