Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: need help with sql

Re: need help with sql

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 02 Mar 2005 18:34:34 -0800
Message-ID: <1109817089.430533@yasure>


Starton X. Mangrove wrote:
> Thanks for nothing. That query is equivalent to Select *
>
> Please read carefully before answering a problem.
>
>
>

>>Query where shared_id <> 0
>>UNION (ALL)
>>Query where shared_id = 0;
>>-- 
>>Daniel A. Morgan
>>University of Washington
>>damorgan_at_x.washington.edu
>>(replace 'x' with 'u' to respond)

Actually the solution I proposed works perfectly as does the one involving decode I think Sybrand proposed. That you can't understand them is hardly a reason to get in a twit.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Wed Mar 02 2005 - 20:34:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US