Re: Creating an ASCII file from an Oracle table

From: Lothar Armbruester <lothar.armbruester_at_rheingau.netsurf.de>
Date: 1997/11/20
Message-ID: <745.263T1753T12874500@rheingau.netsurf.de>#1/1

RobW95 wrote:
>My new company has asked me to create a flat file from an Oracle table (don't
>ask me why). I don't recall any easy way to do this, such as a utility. Does
>anybody have any suggestions? Thanks. Rob

You can do that with SQL*Plus:

set pagesize 0
set termout off
set feedback off
set timing off
spool <yourfile>
select * from <yourtable>
spool off
exit

Put that in a script file and feed it to SQL*Plus.

Maybe I forgot some set statements. You should check the output and read the section on environment variables in manual of SQL*Plus to find out.

Hope that helps!

Lothar

--
Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Schulstr. 12            | lothar.armbruester_at_t-online.de
D-65375 Oestrich-Winkel |

Received on Thu Nov 20 1997 - 00:00:00 CST