Re: just text file from oracle

[Mark Nessfield]

There are various ways in Oracle (Toad, Loader, sql*plus) to export table rows.
Some are explained here:

http://en.allexperts.com/q/Oracle-1451/Export-text-files.htm

(of course if you google "oracle export text" you can find out lots on this)

A quick way in sql*plus is to spool the output to a file.
For example
spool table.txt
select * from em0p;
spool off

You need to set various options in sqlplus to make the output tidier
eg set pagesize 0
set linesize 500
set heading off
set feedback off
set underline off
set define off

----------------------------------------------------------------------------------
Follow my progress with mysql (English/Spanish) at my blog http://www.oxfordtechnotes.co.uk/sqlblog/blog4.php