Re: comma delimited memo field again...

From: Fraser Boswell <Fraser.Boswell_at_spamme.ed.ac.uk>
Date: Thu, 24 Jun 1999 09:18:15 +0100
Message-ID: <3771E9C7.7FACA2B3@spamme.ed.ac.uk>

Try Select fielda, fieldb, '"'||memofield||'"' ...from table The Double quote should keep it together

Fraser

german.chai_at_alumni.ust.hk wrote:

> Hi,
>
> I have some fields (memo) contain "," as puntuation, how can i export
> this kind of flat file to Oracle8 by using comma delimited format?
>
> or is there any other delimiter oracle can recongnise, say "|".
>
> but if using comma is still possible, I perfer!
>
> Tons of Thanks
>
> newbie oracle user
> German
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Jun 24 1999 - 03:18:15 CDT