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

From: Brian <brian_at_databaseknowledge.com>
Date: 9 Mar 2005 13:04:01 -0800
Message-ID: <1110402241.125434.6310@z14g2000cwz.googlegroups.com>

Here's the whole query...i left out a line above:

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
               )

select * from y Received on Wed Mar 09 2005 - 15:04:01 CST