From daemon Sun Mar  3 21:02:34 1996
Received: from ccvm.sunysb.edu by alice.jcc.com; (5.65v3.0/1.1.8.2/01Aug94-0142PM)
 id AA11938; Sun, 3 Mar 1996 21:02:30 -0500
Message-Id: <9603040202.AA11938@alice.jcc.com>
Received: from CCVM.SUNYSB.EDU by ccvm.sunysb.edu (IBM VM SMTP V2R3)
   with BSMTP id 0728; Sun, 03 Mar 96 20:46:29 EST
Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV@SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 4202; Sun, 3 Mar 1996 20:46:27 -0500
Date:         Mon, 4 Mar 1996 09:46:00 +0800
Reply-To: "ORACLE database mailing list." <ORACLE-L@ccvm.sunysb.edu>
Sender: "ORACLE database mailing list." <ORACLE-L@ccvm.sunysb.edu>
From: CHANCL <CHANCL@AM.NIE.AC.SG>
Subject:      Re: SQL Loader - How to load userid without hardcoding
X-To:         ORACLE-L@ccvm.sunysb.edu
To: Multiple recipients of list ORACLE-L <ORACLE-L@ccvm.sunysb.edu>

Hi Dave & Keng Cheng !

My Qn :
>> Can anyone tell me the syntax for OR in SQL Loader ?

Your Sol :
Put both conditions into the same control file.


Thanks 4 your replies.

Exactly, I have 6 col in my tables, namely, userid, tablecounter, F1,
F2, F3 & F4.

The last 4 fields (F1 or F2 or F3 or F4) can be null.
However, in a row the condition
F1 is not null or F2 is not null or F3 is not null or F4 is not null
must be met.

If I use your sol, I will have 15 conditions in my control table, .ie.
F1 not null, F2 not null, F3 not null, F1 not null.
F1 null, F2 not null, F3 not null, F1 not null. etc

I find it very inefficient since 1 condition
F1 is not null or F2 is not null or F3 is not null or F4 is not null
is sufficient IF ONLY I can find the syntax for OR in SQL Loader.
(sigh) ...

Anyway, thanks for your advice.

I appreciate it.

ChorLing
chancl@nievax.nie.ac.sg