Question about DECODE
Date: Fri, 22 Aug 2008 10:40:16 -0700 (PDT)
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