Re: sql command for exporting data to ascii file

Stefan den Engelsman wrote:

> Hello,
>
> Can anyone tell me if oracle does have a sql command which exports the
> contents of a table to an ascii file :
>
> for example :
>
> copy table test
> (
> field1 colon,
> field2 colon,
> field3 nl
> )
> into 'file';
>
> would result into :
>
> file :
> ---------------
> value1:value2:value3
> value1:value2:value3
> etc.
>
> Thanks in advance

Try this :-

spool abcd.txt
select field1,':',field2,':',field3 from <table_name>; spool off

Thanks
Sai Received on Tue Jan 26 1999 - 15:58:36 CST