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

Home -> Community -> Usenet -> c.d.o.server -> SQL*Loader WHEN Clause

SQL*Loader WHEN Clause

From: Hong Wang <hwang_at_atlanta.glenayre.com>
Date: 1998/01/29
Message-ID: <886110384.1658585103@dejanews.com>#1/1

I have the following statement in the SQL*Loader control file for loading the data into a table.

LOAD DATA
....

INTO TABLE tmp
WHEN (1:2)='1' I'd like to change the WHEN clause to something like

WHEN (1:2)='1' OR (1:2)='2' OR ... Does SQL*Loader support it? I could not find it anywhere in the ORACLE Server Utilities manual. I tried a number of different ways using 'OR' and '|', and it always gave an error. I keep thinking this is a simple thing, and I may just not use the right syntax. Can someone point it out for me? Thanks.

Hong
email: hwang_at_atlanta.glenayre.com

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Thu Jan 29 1998 - 00:00:00 CST

Original text of this message

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