OraFAQ Forum: Server Utilities » Sqlloader control file

Home » RDBMS Server » Server Utilities » Sqlloader control file

Fri, 03 May 2002 00:53

Amita Kapadia
Messages: 8
Registered: January 2002

Junior Member

hi,

in oracle control file for sqlloader, how to discard cust.no not starting with 72. how to use when clause in control file.

thanks

Tue, 04 June 2002 08:04

Mike
Messages: 417
Registered: September 1998

Senior Member

example:

load data
infile 'xxx.xxx'
...
into table XXX
WHEN cust_no NOT LIKE '72%'
(...)

Fri, 06 September 2002 04:33

rakhi
Messages: 1
Registered: September 2002

Junior Member

you can use decode in sql control file

Previous Topic:	Oracle
Next Topic:	Skip in SQL LOADER

Goto Forum:

]

Current Time: Sat May 04 06:46:45 CDT 2024