sqlldr when problem! [message #70393] |
Thu, 06 June 2002 23:48 |
happyhero
Messages: 10 Registered: April 2002
|
Junior Member |
|
|
hi,
I meet the question that i use the sqlldr. I want to point the condition with 'or'. but It only support 'and' , How do i? help! help!
|
|
|
Re: sqlldr when problem! [message #70404 is a reply to message #70393] |
Mon, 10 June 2002 06:32 |
Mike
Messages: 417 Registered: September 1998
|
Senior Member |
|
|
use two when clauses.
for example,
load data
infile 'abcd.ctl'
truncate
into table AAA
when a = "10"
fields terminated by .......
(a1, a2, a3)
into table AAA
when a = "20"
fields terminated by .......
(a1, a2, a3)
|
|
|