DECODE QuestionHi,
From: Mtek <mtek_at_mtekusa.com>
Date: Fri, 22 Aug 2008 10:47:00 -0700 (PDT)
Message-ID: <f130728b-7d44-4c1c-aa13-a3c323c86b01@d1g2000hsg.googlegroups.com>
Date: Fri, 22 Aug 2008 10:47:00 -0700 (PDT)
Message-ID: <f130728b-7d44-4c1c-aa13-a3c323c86b01@d1g2000hsg.googlegroups.com>
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:47:00 CDT