Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL*Loader WHEN Clause
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 UsenetReceived on Thu Jan 29 1998 - 00:00:00 CST