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

Hello,

login with sqlplus, than at the command line type:

set head off
spool yourfilename
select * whatever
spool off
exit

Now ou have a file calleed yourfilename.lst with the text "Huiqun Zhou" <zhou_at_ra2.so-net.ne.jp> schrieb im Newsbeitrag news: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 Thu Sep 20 2001 - 08:41:48 CDT