Re: How do I export Oracle table data to a csv file

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Fri, 10 Jan 2003 20:57:45 -0000
Message-ID: <3e1f3489_3@mk-nntp-1.news.uk.worldonline.com>

<reji.mathews_at_capita.co.uk> wrote in message news:38788d11.0301101134.2e0414ec_at_posting.google.com...
> I am trying to export Oracle Data to csv file but it fails to export
> some of the data.
> Following is the syntax I am using:
>
> SET ECHO OFF HEADING OFF NEWPAGE 0 FEEDBACK OFF LINESIZE 10000
> PAGESIZE 0 WRA OFF RECSEP OFF CON OFF TRIM ON TRIMS ON VERIFY off
> doc off
>
> --FAQ.bat--
> sqlplus -s userid/password_at_hoststring @faq.sql > faq.csv
>
> --FAQ.sql--
> select
> '"'||FAQ_NUMBER

||'","'||FAQ_CATEGORY||'","'||QUESTION||'","'||ANSWER||'","'||RELATED_LINK|| '","'||AUDIENCE||'","'||FAQ_VALID
> from FAQ_INFOBASE
> order by FAQ_NUMBER;
>
> exit
>
>
> The column ANSWER has most of the special characters. Please Please
> help me out
>
>

Have a look at Golden Retriever from Benthic Software -

www.benthicsoftware.com

It costs peanuts (about USD35, and you can download a free trial before paying anyway). It has a .exe included called ImpExp32, which will do all this and much more.

I have no connection whatever with this software, other than as an extremely satisfied user over many years.

Regards,
Paul Received on Fri Jan 10 2003 - 14:57:45 CST