Re: How to export table data to a text file?

From: Andreas Stephan <andreas.stephan.as_at_bayer-ag.de>
Date: Fri, 21 Sep 2001 11:31:30 +0200
Message-ID: <9of1di$sbi4@byz672.bayer-ag.com>

Hi Zhou,

you can user sql*plus to create a file with "delimited" data. Example:

sqlplus > spool my_textfile.txt;
sqlplus > set heading off;
sqlplus > set echo off;
sqlplus > set linesize 999;
sqlplus > set pagesize 0;
sqlplus > select field1||','||field2||',' ...  from table_one order by

blabla;
sqlplus > spool off;

hth
Andy

Huiqun Zhou <zhou_at_ra2.so-net.ne.jp> schrieb in im Newsbeitrag: 9ocqtr$t9b$1_at_news01ce.so-net.ne.jp...
> Hi,
>
> I'm a newbie for Oracle. Could anyone let me know how to export
> data of a table into a text file? Is exp the right tool?
>
> Thanks,
>
> zhou
>
Received on Fri Sep 21 2001 - 04:31:30 CDT