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