Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: using sqlldr to extract the content of table to a file
Wilfrid wrote:
> Hello,
>
> I am using Oracle 9.2.0.1.
> I would like to extract the content of a table to a csv file. I am already
> using a bit sqlldr to load data into the DB and I was wondering if the other
> way around is possible?
> Or may be there is another way/tool for doing this.
> Thanks for your help
> Wilfrid
>From within SQL*Plus:
SQL> set colsep , SQL> spool <filename> SQL> select * from <table_name>; SQL> spool off
HTH
-g
Received on Wed Sep 27 2006 - 06:11:10 CDT