OraFAQ Forum: Server Utilities » how to use < > operators in WHEN clause sql *LOADER control file

Home » RDBMS Server » Server Utilities » how to use < > operators in WHEN clause sql *LOADER control file (oracle10gR2 RHEL5)

Mon, 18 July 2011 03:26

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
(
.....
.....
)

Mon, 18 July 2011 03:35

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

Senior Member

And the error is?

Mon, 18 July 2011 03:39

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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: Mon Dec 23 11:10:36 CST 2024