MySQL Forums
Forum List  »  Oracle

Re: just text file from oracle
Posted by: Mark Nessfield
Date: June 15, 2008 02:10PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
3948
April 28, 2008 07:03AM
Re: just text file from oracle
3742
June 15, 2008 02:10PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.