Re: Sql Loader

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Fri, 12 May 2000 14:39:32 -0400
Message-Id: <10495.105547@fatcity.com>

This is almost certainly a problem that you'll need to fix at the source of your data feed. You may "know" that d'conner is really one name, but SQL*Loader won't know that. I'm not sure, but I don't think that SQL*Loader will recognize any sort of escape character.

Jonathan

On Thu, 11 May 2000 09:36:21 -0800, you wrote:

>I am using single quote (') or comma (,) as delimiter
>in mine text files but sometimes I used to get data
>like d'connor etc and in this case mine record is
>rejected or also sometime data comes as
>india,usa,canada but it has to go into one field and
>it fails as I am using comma as delimiter.
Received on Fri May 12 2000 - 13:39:32 CDT