Re: Very urgent!!! how to export data of table column to a file

Stephan Gloor <sgloor_at_hso.ch> schrieb im Beitrag <329AC859.21EF_at_hso.ch>...
> Hi there.
>
> We're running Oracle Server 7.2x on Windows NT. We need to write column
> data to a file. The file shouldn't be formatted. When using export the
> file is formatted in Oracle binary format.
> How can we automate this process ?
>
> Thank your for the eMailed hint.
>
> Stephan Gloor <sgloor_at_hso.ch>
> --
> HSO Information Engineering
> Baumackerstr. 24
> 8045 Zürich
> tel: +41 1 316 60 30 fax: +41 1 312 20 72
> eMail: sgloor_at_hso.ch
>

Hallo Stephan,
simple create an sql- script
like the following:

spool c:\temp\spoolfile
select * from tablename;
spool off

you can as well switch out the headings and page changes whith the "set" command.

Nice Greetings
Lothar Dickhoff Received on Wed Nov 27 1996 - 00:00:00 CST