sqlldr

From: Jon <zaphod_at_beblebrox42.org>
Date: Tue, 19 Nov 2002 01:21:25 GMT
Message-ID: <Xns92CAC51096543zaphod42@207.217.77.26>

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 Received on Mon Nov 18 2002 - 19:21:25 CST