Home » RDBMS Server » Server Utilities » sql loader skip blank line (solaris)
sql loader skip blank line [message #548229] Tue, 20 March 2012 23:18 Go to next message
supernova122
Messages: 1
Registered: March 2012
Junior Member

I am running Oracle 9 and using sql loader to import text file into table. Can sql loader skips the record which blank line or carriage return? Do I need to set up with options? Please advise me how. Thanks.
Re: sql loader skip blank line [message #548233 is a reply to message #548229] Wed, 21 March 2012 00:02 Go to previous message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
Records where all fields are null are automatically rejected and not loaded.

Previous Topic: Oracle 9i V/s Oracle 10g Import / Export Problem
Next Topic: SQL Loader Help
Goto Forum:
  


Current Time: Fri Mar 29 07:47:52 CDT 2024