Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: sqlldr

Re: sqlldr

From: Edward J. Prochak <ed.prochak_at_magicinterface.com>
Date: Fri, 22 Nov 2002 04:47:38 GMT
Message-ID: <3DDDB9B1.2060604@magicinterface.com>


Jon wrote:
> Hi All,
> I have run into a situation with SQLLoader (8.1.5 / hp-ux 11). I now
> have a situation that I will now have more than one type of recid needing
> to be loaded into a table.
>
> Currently I use a "when recid='xxx'", now I need something like "when
> recid='xxx' or recid='yyy'". From what I can tell from the docs, and
> trial & error it will only take a "when recid='xxx' AND recid='yyy'". I
> really need the OR clause instead.
>
> Short of duplicating the entire statement several times is there some
> sort of "OR" that I am missing?
>
> Thanks and regards
> Jon

Short answer: NO

-- 
Edward J. Prochak   --- Magic Interface, Ltd.
Ofc: 440-498-3700   --- 7295 Popham Place, Solon, OH 44139
on the web at       --- http://www.magicinterface.com
email: ed.prochak_at_magicinterface.com
Received on Thu Nov 21 2002 - 22:47:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US