Re: Query that returns 2 different results in 9iRAC and 10gRac

Brian wrote:

> Try this query on 9iRac and 10gRac, it returns 2 differnet results.
>
> with qw as (select inst_id from gv$session),
> y as (
> select unique inst_id
> from qw
> union all
> select unique inst_id
> from qw
> )
>
> I logged a tar and was told this is not a bug. The explanation made no
> sense whatsoever.

Nothing you've posted makes sense either.

How about the actual SQL and the explanation you received from Oracle?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)