OraFAQ Forum: Server Utilities » Condition in SqlLoader [Merged]

Home » RDBMS Server » Server Utilities » Condition in SqlLoader [Merged]

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

Condition in SqlLoader [Merged] [message #299643]

Tue, 12 February 2008 17:30

kham2k
Messages: 34
Registered: May 2007

Member

Hi All
I want to find out is that how to give a condition is sqlldr

load data
infile 'file.TXT'
into table abc.table
when
upc_id > 99
append
(upc_id position(1:10),
..


SQL*Loader: Release 9.2.0.4.0 - Production on Tue Feb 12 15:23:29 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL*Loader-350: Syntax error at line 5.
Illegal combination of non-alphanumeric characters
upc_id > 99
       ^

What will be the best to use less then also i know that i can use 'and' but 'or' can't be used there

Regards,

Report message to a moderator

Re: Condition in SqlLoader [message #299658 is a reply to message #299643]

Tue, 12 February 2008 21:34

ebrian
Messages: 2794
Registered: April 2006

Senior Member

What happens if you format as:

load data
infile 'file.TXT'
into table abc.table
append
when upc_id > 99
(upc_id position(1:10),
..

Report message to a moderator

Previous Topic:	Field in data file exceeds maximum length Error
Next Topic:	Are inserts NLS sensitive?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 22:36:01 CST 2024