Re: using sqlldr to extract the content of table to a file

gazzag wrote:
> 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

Until you run into those rows where some of the data has commas... and ampersands... and vertical bars... and unprintable characters...

jg

--
@home.com is bogus.
"And the fact that one man - one channel is coming true, makes me feel
really good."
 http://www.firezine.net/issue1/fz1_03.htm
"We let you create your own television programming and then broadcast
it directly to the TV."
http://www.signonsandiego.com/uniontrib/20060927/news_1b27demo.html