Re: Question about DECODE

From: DA Morgan <>
Date: Fri, 22 Aug 2008 21:09:14 -0700
Message-ID: <>

Mtek wrote:
> 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??

  • Duplicate Post ***

Please post only one message in one group. Thank you.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Fri Aug 22 2008 - 23:09:14 CDT

Original text of this message