Home » RDBMS Server » Server Utilities » how to use < > operators in WHEN clause sql *LOADER control file (oracle10gR2 RHEL5)
how to use < > operators in WHEN clause sql *LOADER control file [message #516439] Mon, 18 July 2011 03:26 Go to next message
9390512774
Messages: 103
Registered: January 2011
Location: hyd
Senior Member
Hi all,

When i am writing < or > symbols in sql loader control file. its giving me the error.the below is the code.
LOAD DATA
REPLACE
INTO TABLE EMP_SAL 
WHEN SAL < 3000 
FIELDS
(
.....
.....
)
Re: how to use < > operators in WHEN clause sql *LOADER control file [message #516441 is a reply to message #516439] Mon, 18 July 2011 03:35 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
And the error is?
Re: how to use < > operators in WHEN clause sql *LOADER control file [message #516442 is a reply to message #516439] Mon, 18 July 2011 03:39 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can only use =.
Try to use external table instead.

Regards
Michel
Previous Topic: SQL*Loader lowercase insert
Next Topic: exporting metadata backup
Goto Forum:
  


Current Time: Thu Mar 28 03:24:33 CDT 2024