Re: Converting oracle table's data into csv on client computer
- From: Paul <paul@xxxxxxxxxxxxxx>
- Date: Fri, 22 Jul 2005 13:54:11 +0100
"nirav" <shivam71@xxxxxxxxx> 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.
.
- Follow-Ups:
- References:
- Prev by Date: Re: Preferred Application Server
- Next by Date: Re: 2 instances on same machine
- Previous by thread: Re: Converting oracle table's data into csv on client computer
- Next by thread: Re: Converting oracle table's data into csv on client computer
- Index(es):
Relevant Pages
|
