Need help with SQL*Loader.
From: Luis Gregorio <luis.gregorio_at_axa-seguros.pt>
Date: Tue, 4 Aug 1998 20:25:19 -0700
Message-ID: <6q7mse$mio$1_at_duke.telepac.pt>
Date: Tue, 4 Aug 1998 20:25:19 -0700
Message-ID: <6q7mse$mio$1_at_duke.telepac.pt>
I have a problem.
I'm trying to load a text file into a Oracle table, that's not the problem,
the problem is that this table has a Date column and my file has some
records with valid dates and same records with invalid dates. Is there a way
of inserting the records that don't have a valid Date (assigning null to the
Date Column)? How?
I've tried using NULLIF but I found two kinds of invalid dates, blank dates and '00000000'. How can I put 2 conditions in the NULLIF clause.
Thank You.
Luis Gregorio
Received on Wed Aug 05 1998 - 05:25:19 CEST