Home » RDBMS Server » Server Utilities » Condition in SqlLoader [Merged]
icon5.gif  Condition in SqlLoader [Merged] [message #299643] Tue, 12 February 2008 17:30 Go to next message
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,
Re: Condition in SqlLoader [message #299658 is a reply to message #299643] Tue, 12 February 2008 21:34 Go to previous message
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),
..
Previous Topic: Field in data file exceeds maximum length Error
Next Topic: Are inserts NLS sensitive?
Goto Forum:
  


Current Time: Sun Dec 04 10:22:17 CST 2016

Total time taken to generate the page: 0.07468 seconds