Re: Sql Loader

From: Rajagopal Venkataramany <rajagopalvr_at_hotmail.com>
Date: Thu, 11 May 2000 20:07:41 GMT
Message-Id: <10494.105413@fatcity.com>

Hi,

The only solution that I can think is to change the delimiter character.

If the data feed from a external system and changing the delimiter is not possible,then write a simple awk program which would read the existing file to generate a new data file with a different delimiter (other than ' or ,).

I do not think usage of POSITION clause will help you as the data length will vary.

Regards
Rajagopal Venkataramany

----Original Message Follows----
From: Navtej B <navtej_b_at_yahoo.com>
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: Sql Loader
Date: Thu, 11 May 2000 09:36:21 -0800

Can somebody help in solving mine Sqlloader problem

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.

SO can somebody help in finding escape kind or any othe rworkaround

I really appreciate the help

Thanks
NavBir

Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/

--
Author: Navtej B
   INET: navtej_b_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

Received on Thu May 11 2000 - 15:07:41 CDT