DECODE QuestionHi,

From: Mtek <>
Date: Fri, 22 Aug 2008 10:47:00 -0700 (PDT)
Message-ID: <>


I have a question about DECODE. I know that I can return a 1 or 0 using DECODE:

SELECT (DECODE...,1,0) FROM <table name> WHERE........;

My question is, what you need to just decode the result of the where? Basically if all the criteria of the WHERE statement is true, return a 1, and if any of the criteria is false, return a 0.

SELECT (DECODE...,1,0) FROM <table name> WHERE........AND.......AND......; Is there a way to do that?? Subqueries? Analytical functions?? Received on Fri Aug 22 2008 - 12:47:00 CDT

Original text of this message