Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL*LOADER
Is it possible to test for a blank line in a data file and NOT upload it? For example, I may have a .dat file like the following:
A 100 B 200 <---- may be a cr/lf in any column, not always the first C 300
I have tried using the WHEN clause combined with the BLANKS operator like this:
WHEN (1:80) <> BLANKS
to no avail. Received on Tue Feb 04 1997 - 00:00:00 CST