OraFAQ Forum: Server Utilities » SQLLDR WHEN condition with IN CLAUSE

Home » RDBMS Server » Server Utilities » SQLLDR WHEN condition with IN CLAUSE (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQLLDR WHEN condition with IN CLAUSE [message #471986]

Wed, 18 August 2010 04:08

palanisvr
Messages: 21
Registered: March 2007

Junior Member

Hi Gurus ,

I have a requirement where i have to insert data using sqlloader where it does not satisfies the condition.

It should work like the below but the below condition is giving syntax error. PLease let me know if you any idea.
Thanks in advance..good day.

LOAD DATA
INTO table emp
WHEN location NOT IN ( 'USA' , 'UK' ) AND EMP_NO NOT IN ( 102 , 101)
(
ename ,
..........
..........
)

Report message to a moderator

Re: SQLLDR WHEN condition with IN CLAUSE [message #471987 is a reply to message #471986]

Wed, 18 August 2010 04:11

cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester

Senior Member

Have you considered using an external table instead?

Report message to a moderator

Re: SQLLDR WHEN condition with IN CLAUSE [message #472003 is a reply to message #471987]

Wed, 18 August 2010 05:04

palanisvr
Messages: 21
Registered: March 2007

Junior Member

I should use only SQL loader to achieve this.

Report message to a moderator

Re: SQLLDR WHEN condition with IN CLAUSE [message #472007 is a reply to message #472003]

Wed, 18 August 2010 05:14

palanisvr
Messages: 21
Registered: March 2007

Junior Member

Finally got the solution....

LOAD DATA
INTO table emp
WHEN location <> 'USA'
AND location <> 'UK'
AND EMP_NO <> 101
AND EMP_NO <> 102
(
ename ,
..........
..........
)

Report message to a moderator