Re: sql*loader

From: John Strange <jstrange_at_imtn.dsccc.com>
Date: 4 Jun 1999 19:34:50 GMT
Message-ID: <7j99oq$jh9$1@relay1.dsccc.com>

when I have to import character strings which might contain ' or " I use the Unit Seperator character (a hex 1f) to enclose the character string.

Now I can have a record like "this is a test" and

^_He said "This is a test"^_
and sqlloader will not have problems with " within the text.

The ^_ is the hex 1f

fields terminated by '"' optionally enclosed by X'1F'

Nandakumar (nanban_at_my-deja.com) wrote:
: Can someone tell me what this 'optionally enclosed by' in sql*loader?
: Appreciate any document related to sql*loader.

: --
: Nandakumar
: New York
: (N.Kumar_at_rocketmail.com)

: Sent via Deja.com http://www.deja.com/
: Share what you know. Learn what you don't.

--
While Alcatel may claim ownership of all my ideas (on or off the job), Alcatel does not claim any responsibility for them. Warranty expired when u opened this article and I will not be responsible for its contents or use. Received on Fri Jun 04 1999 - 14:34:50 CDT