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

In article <329AC859.21EF_at_hso.ch>, Stephan Gloor <sgloor_at_hso.ch> wrote:
>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>
>
If you are talking about creating a flat file from a database table you could use a SQL*Plus script such as the following :-

SET NEWPAGE 0
SET SPACE 0
SET LINESIZE 80
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF
SPOOL output.data
SELECT COLUMN1, COLUMN2, COLUMN3
FROM TABLE
WHERE ......
SPOOL OFF Received on Tue Nov 26 1996 - 00:00:00 CET