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

serabell_at_eos.hitc.com (Sharmishta Erabelli) wrote:
>
> Is there a way to dump data from an Oracle table into a flat ASCII with a
> specified delimiter.
>

Assuming you want the delimiter to be a comma do the following:

In SQL*PLUS:

set heading off
set pages off

spool myfile.txt

select filed1 ||','|| filed2 ||','|| filed3 .... etc from atable;

spool off

I Hope this helps

Yours ever

Eddy Received on Wed May 03 1995 - 00:00:00 CEST