Re: Creating an ASCII file from an Oracle table

Lothar Armbruester wrote:
>
> 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
>

In addition, if you want to output a comma-delimited file, you could also:

set pagesize 0
set linesize <maxwidthyouwant>
set head off
set termout off
set feedback off
set timing off
spool <yourfile>
select COL1||','||COL2||','||COL3 ... ||','||COLn from mytable ... spool off
exit

Yours,

Geoff Houck
systems hk
2hksys_at_teleport.com [Delete the "2" to respond] http://www.teleport.com/~hksys Received on Thu Nov 20 1997 - 00:00:00 CST