Re: SQL*loader when clause for multiple values Correction to last post
From: Bricklen <bricklen_at_shaw.ca>
Date: Tue, 02 Apr 2002 16:48:46 GMT
Message-ID: <3CA9E01F.2857855_at_shaw.ca>
Date: Tue, 02 Apr 2002 16:48:46 GMT
Message-ID: <3CA9E01F.2857855_at_shaw.ca>
[Quoted] 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 - 18:48:46 CEST