Re: comma delimited memo field again...

From: Mark G <mgumbs_at_nospam.hotmail.com>
Date: Thu, 24 Jun 1999 09:03:51 +0100
Message-ID: <3771e410.0@145.227.194.253>

Oracle (and sql*loader) can recognise any delimeter. You just tell it what it is.

You can use commas but if the field has commas embedded in it, you have to enclose that field with quotes.

e.g The,Cat,sat,"on the,rugged",mat

Personally, i prefer '|'

Mark

german.chai_at_alumni.ust.hk wrote in message <7ksg51$sl8$1_at_nnrp1.deja.com>...
>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:03:51 CDT