| 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)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
