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

Home -> Community -> Usenet -> c.d.o.server -> SQL*LOADER

SQL*LOADER

From: Shane Murray <smurray_at_bah.com>
Date: 1997/02/04
Message-ID: <32f6aa46.92310233@news>#1/1

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

Original text of this message

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