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

Home -> Community -> Usenet -> c.d.o.server -> Re: Query not returning same results when displaying one column less

Re: Query not returning same results when displaying one column less

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Tue, 22 Feb 2005 11:39:04 -0800
Message-ID: <1109100965.319566@yasure>


Marc Eggenberger wrote:

> Hi there.
>
> I have an Oracle Database 8.1.7.0.0 running on Windows 2000 SP4.
> I have a query from one customer which gives a different result when
> displaying one column less. No change to the where clause or the joins.
> Shouldnt then the same results be returned?

This may not be the correct answer but why are you running on an unsupported version of Oracle that has not been patched since its release? At least get to 8.1.7.4 and try again before asking.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Tue Feb 22 2005 - 13:39:04 CST

Original text of this message

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