Re: Is there a simplified code than this?
From: yvette.millington <yvette.millington_at_easynet.co.uk>
Date: Wed, 30 Jun 1999 08:49:10 +0100
Message-ID: <7lcrhq$giu$1_at_quince.news.easynet.net>
Date: Wed, 30 Jun 1999 08:49:10 +0100
Message-ID: <7lcrhq$giu$1_at_quince.news.easynet.net>
Qingbo Zheng wrote in message <3778D682.F60D6F74_at_udel.edu>...
>UPDATE cadsrdb.population
>SET births = NULL,
. . .
>where births = 0 OR
> deaths = 0 OR
. . .
>UPDATE cadsrdb.population
>SET births = DECODE(births,0,NULL,births)
etc . . . saves little in typing, but does get rid of the OR in the where
clause, and maybe looks more comprehensible
Received on Wed Jun 30 1999 - 09:49:10 CEST