Question about DECODE

#1

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??

#2

Mtek wrote:

Quote:

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
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#3

Mtek wrote:

Quote:

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
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#4

Mtek wrote:

Quote:

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
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#5

Mtek wrote:

Quote:

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
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Question about DECODE

comp.databases.oracle.misc comp.databases.oracle.misc

Question about DECODE - 08-22-2008 , 12:40 PM

Re: Question about DECODE - 08-22-2008 , 11:09 PM

Re: Question about DECODE - 08-22-2008 , 11:09 PM

Re: Question about DECODE - 08-22-2008 , 11:09 PM

Re: Question about DECODE - 08-22-2008 , 11:09 PM