Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL-statement

Re: SQL-statement

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: Wed, 20 Apr 2005 13:53:35 +0000 (UTC)
Message-ID: <d45msv$96c$1@klatschtante.init7.net>


On 2005-04-20, Ken Denny <ken_at_kendenny.com> wrote:
> I would do one thing differently than Rene. I would calculate the
> non-active a bit differently. I would use this to calculate non-active:
>
> sum(decode(nvl(e.active,0),0,1,0))

yes, that seems reasonable. Thanks
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/
Received on Wed Apr 20 2005 - 08:53:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US