Re: Sql Loader

From: Jay Hostetter <jhostetter_at_decommunications.com>
Date: Thu, 11 May 2000 14:22:51 -0400
Message-Id: <10494.105398@fatcity.com>

When I encounter this problem, I change the delimiter. Hopefully, that is = an option. I have found characters like ~ and | make good delimiters.

Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA USA

>>> Navtej B <navtej_b_at_yahoo.com> 05/11/00 01:36PM >>>
Hi

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/=20
--=20
Author: Navtej B
  INET: navtej_b_at_yahoo.com=20

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). Received on Thu May 11 2000 - 13:22:51 CDT