Q: using WHEN in SQL*Loader?
From: Oriar Migo <no-spam_at_here.uhh>
Date: Mon, 28 Sep 1998 10:38:04 +0200
Message-ID: <360F4AEC.78CBF93A_at_here.uhh>
Hi,
Date: Mon, 28 Sep 1998 10:38:04 +0200
Message-ID: <360F4AEC.78CBF93A_at_here.uhh>
Hi,
I need some help with how to use WHEN to load rows with an "empty" field in a comma-separated file?
Example extract from the data file
--- id1,surname1,,lastname1,mail1 id2,surname2,lastname2b,lastname2,mail2 -- I simply want to skip all rows with two lastnames. I have tried using WHEN column3 = BLANKS (or '') but all rows failed. And anything else I try also fails... so I'm out of ideas. /FrederickReceived on Mon Sep 28 1998 - 10:38:04 CEST