Re: SQL*loader when clause for multiple values Correction to last post

From: TurkBear <jgreco1_at_mn.rr.com>
Date: Tue, 02 Apr 2002 11:07:32 -0600
Message-ID: <p6pjau88no3hmak3m1aqdfamt4afnsd2gt_at_4ax.com>


[Quoted] I believe so, but I haven't tried it for a long while so I may be remembering badly ( sometimes I am affected with CRAFT - Can't Remember A Freakin' Thing) ...
( My understanding is that almost any valid sql expression can be used)

Bricklen <bricklen_at_shaw.ca> wrote:

>You can use the IN keyword in the WHEN clause?! that's handy!!
>
>
>TurkBear wrote:
>>
>> Sorry , please remove the first parens after the when
>> WHEN LOCATION_COUNTRY_CODE IN ( 'FR','DK','IS')
>> ( LOCATION_ID,
>> etc...
>> RECORD_STATUS
>> ) NOTE End of first WHEN clause parens here
>> Keep only 1 parens at the end
>[snipped]
Received on Tue Apr 02 2002 - 19:07:32 CEST

Original text of this message