Re: novice: extract comma delimited data

The other people answered your question but I feel I have to say something about putting data in comma delimited format. If you plan on loading that file into something else and telling it that it is comma delimited you should make sure that none of the fields are filled with text. Commas are commonly used by people and it will throw your loading off if there is one in there. I struggled with that once and now when I get a comma delimited extract I call and make them change to tab delimited and I have had far fewer problems.

Darren

Furkan Khan wrote:

> Folks, I am a novice at SQL, its been quite some time since I used
> it. Can someone recommend me the best way to dump out data
> from an oracle table into comma delimited form.
>
> I know the the Oracle Navigator allows it via the gui, but I want
> a sql script or some other scripting utility.
>
> Thanks in advance. You can mail me directly also.
>
> Regards.
> Furkan Khan

Received on Tue Apr 27 1999 - 09:12:36 CDT