OraFAQ Forum: Server Utilities » Multiple When Clause

Home » RDBMS Server » Server Utilities » Multiple When Clause

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

Multiple When Clause [message #73357]

Thu, 01 April 2004 02:42

sri
Messages: 154
Registered: February 2000

Senior Member

How can I put two conditions on my control file. Something like when (XYZID!='XYZID Incremental Directory')� OR (XYZID!='ABCD')

Please suggest an effecient solution if possible. Thankx

Sri

Report message to a moderator

Re: Multiple When Clause [message #73382 is a reply to message #73357]

Tue, 06 April 2004 23:57

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Hi,

You can only combine conditions with AND, not OR. As workaround, you could try something like this:

LOAD DATA
...
INTO TABLE tab1 
WHEN XYZID!='XYZID Incremental Directory'
...
INTO TABLE tab1
WHEN XYZID!='ABCD'
...

Best regards.

Frank

Report message to a moderator

Previous Topic:	ora-00942
Next Topic:	I want to generate sequence value on duplicate data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 05:48:55 CDT 2024