Re: Export data in ASCII format.

From: Peter Thaller <pthaller_at_sime.com>
Date: Sat, 24 Oct 1998 00:30:58 +0100
Message-ID: <909181550.736739@arctica.sime.com>

hi kelvin!
kelvinw_at_asymetrix.com schrieb in Nachricht <3630a9f3.252478194_at_news>...
>
>Hi everybody,
>
>I have a bunch of tables needed to be exported in ASCII format with
>comma delimited and loaded up to a spreadsheet. I have tried the
>exp73.exe utility. It seems to me that it can only export table data
>in a Oracle format. Does anyone have an idea how to export table
>data in ASCII format.
>

write a script and run from sqlplus:

spool file1
select field1||';'||field2||';'|| ... from tab1; spool off
spool file2
select field1||';'||field2||';'|| ... from tab2; spool off
.
.

hope you have not too much data.
after doing this you may edit the files. peter Received on Fri Oct 23 1998 - 18:30:58 CDT