Home » RDBMS Server » Server Utilities » SQL * Loader Problem
icon7.gif  SQL * Loader Problem [message #244908] Thu, 14 June 2007 09:51 Go to next message
Messages: 6
Registered: May 2007
Junior Member
I am using SQL*Loader to insert record from the flat file to table.

My problem is if any line in a file starts with "E" or "W"
i should not insert that record. I need to skip that record move to the next line .
Is it possible to check ... if so pls can u pls send me the sample code.

Thanks In Advance..
Re: SQL * Loader Problem [message #245365 is a reply to message #244908] Sat, 16 June 2007 08:52 Go to previous messageGo to next message
Messages: 20847
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't have Oracle here to test it, but you might look at the WHEN clause (check the Loading records based on a condition section).
Re: SQL * Loader Problem [message #245366 is a reply to message #244908] Sat, 16 June 2007 09:17 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
This should help - http://www.orafaq.com/faq/can_one_selectively_load_only_the_records_that_one_need
Previous Topic: Import from Oracle7 to Oracle 10g
Next Topic: SQL Loader not starting from Solaris
Goto Forum:

Current Time: Fri Oct 28 06:15:43 CDT 2016

Total time taken to generate the page: 0.10662 seconds