Question about DECODE

Hi,

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:40:16 CDT