Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How to skip blank records using sql*loader

How to skip blank records using sql*loader

From: Cale, Rick T (Richard) <RICHARD.T.CALE_at_saic.com>
Date: Tue, 15 Aug 2000 04:08:48 -0700
Message-Id: <10590.114582@fatcity.com>


Hi DBAs,

I have a file that I need to load using sql*loader. However the file has many blank lines in it.
Short of editing the file is there a way to have sql*loader ignore blank lines?

Thanks
Rick Received on Tue Aug 15 2000 - 06:08:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US