Q: SQL*Loader NULLIF in date

From: Ralf Bender <ralf.bender_at_arcor.de>
Date: Thu, 06 Nov 2003 15:22:11 +0100
Message-ID: <3faa588c$0$24759$9b4e6d93@newsread2.arcor-online.net>

Hello

i got a stupid problem here. i've got to load thousands of data with sql*loader. normally no problem. but there are a few records which i don't know to handle with.

the last field is my problem:

30106053;1WES02;4082646;..
30109055;1WES03;4085598;..
30121980;1WES05;4098442;..

normally it's a date here. now i want do write as NULL in db. but how?

NULLIF date=blanks, should not be right, because it is not blank

thx for helping
ralf Received on Thu Nov 06 2003 - 08:22:11 CST