Re: sql*loader

From: Nandakumar <nanban_at_my-deja.com>
Date: Mon, 07 Jun 1999 18:08:05 GMT
Message-ID: <7jh1pu$u1d$1@nnrp1.deja.com>

Hi John,
Thanks for your information on 'optionally enclosed by'. Just to express my understanding on this, Say there is a table with two columns of type char. There are some input data like

"Chennai" "Mumbai"            # First row
'Delhi "New York"' "Denver"   # second row.
'Miami'   'California'        # Third Row

Now when data is loaded with 'optionally enclosed by' the contents of the two columns in the table will look like:

COlumn1 column2

---

Chennai Mumbai
Delhi New York Denver
Miami California

Pls. correct me if if i am wrong.
Thanks &
regards
Nanda

In article <7j99oq$jh9$1_at_relay1.dsccc.com>,   jstrange_at_imtn.dsccc.com (John Strange) wrote:
> 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.
>

--
Nandakumar
Systems Analyst
New York
(N.Kumar_at_rocketmail.com)

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jun 07 1999 - 13:08:05 CDT