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

Home -> Community -> Usenet -> c.d.o.server -> Re: Use DECODE result in WHERE clause?

Re: Use DECODE result in WHERE clause?

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Wed, 19 Sep 2007 10:44:40 -0400
Message-ID: <5lcqubF7m5q9U2@mid.individual.net> 





Serge Rielau wrote:


> SELECT 1/c1 AS X FROM T WHERE c1 IS NOT NULL

Correction:


SELECT 1/c1 AS X FROM T WHERE c1 <> 0



Still early in the morning...


Cheers


Serge

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab


Received on Wed Sep 19 2007 - 09:44:40 CDT












Original text of this message













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