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 -> Query that returns 2 different results in 9iRAC and 10gRac

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

From: Brian <brian_at_databaseknowledge.com>
Date: 9 Mar 2005 12:58:44 -0800
Message-ID: <1110401924.577897.229500@z14g2000cwz.googlegroups.com>


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. Received on Wed Mar 09 2005 - 14:58:44 CST

Original text of this message

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