Re: How do we do an ascii dump of a table with a delimiter ?

> Is there a way to dump data from an Oracle table into a flat ASCII with a
> specified delimiter.
>
> I'd appreciate if you can send an email to me.
> thanks
>
> --
> Sharmishta Erabelli serabell_at_eos.hitc.com
> Hughes Applied Information Systems
> 1616A McCormick Drive
> Landover, MD 20785
> Ph: (301)925-0489

you may want to try the following

set pagesize 0
set linesize 1000
spool filename  

select col1, ',', col2, ',', col3, ',', col4 ... from your table;

spool off

this will output the table into filename on your system. hope this helps
  Received on Wed May 03 1995 - 00:00:00 CEST