Xref: alice comp.databases.oracle.tools:27487
Path: alice!news-feed.fnsi.net!netnews.com!news.maxwell.syr.edu!easynet-tele!easynet.net!quince.news.easynet.net!not-for-mail
From: "yvette.millington" <yvette.millington@easynet.co.uk>
Newsgroups: comp.databases.oracle.tools
Subject: Re: Is there a simplified code than this?
Date: Wed, 30 Jun 1999 08:49:10 +0100
Organization: [posted via Easynet Ltd]
Lines: 15
Message-ID: <7lcrhq$giu$1@quince.news.easynet.net>
References: <3778D682.F60D6F74@udel.edu>
X-Trace: quince.news.easynet.net 930738554 16990 212.212.95.248 (30 Jun 1999 10:29:14 GMT)
X-Complaints-To: abuse@easynet.net
NNTP-Posting-Date: 30 Jun 1999 10:29:14 GMT
X-Newsreader: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3


Qingbo Zheng wrote in message <3778D682.F60D6F74@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