Re: Converting oracle table's data into csv on client computer

"nirav" <shivam71_at_gmail.com> wrote:

>I am on , what I think is a tough job...I have to give a facility or a
>way to each user to have a table or more than one table converted to a
>csv (comma seperated value) format.

Why?

>(Oracle 9i on solaris). The developers have sqlplus installed.

Do you mean developers or users? What is the difference in your organisation?

> Now
>from sqlplus how do we manage ALL types of data (and there are tables
>that have LONG columns , there are tables that have commas and pipes
>and single quotes-all those tiny things that create issues)

Billy has given you some stuff (which I haven't looked at BTW (yet)).

But, if that fails, try asktom - I saw an article about producing csv files on there a wee while ago. Why .csv though? Is it to get the data into Excel spreadsheets or something? Just curious!

>Any ideas on : 1) How can we manage this using sql?

Not in this lifetime!

>2) If you are definately sure that sql will fail then any ideas on how
>we can use pl/sql?

See Billy's post or asktom.

>To add the work: The convertion should be done on client computer and
>not on sever. (But pl. give ideas if you have solution for doing on
>server)

What OS are the clients running? Do you use any other programming tools within your organisation to access the data other than Oracle supplied ones?

Paul...

>Shreyaas

-- 

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2, 

Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.1.0;

When asking database related questions, please give other posters 
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.
 
Furthermore, as a courtesy to those who spend 
time analysing and attempting to help, please 
do not top post.