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

From: Brian <brian_at_databaseknowledge.com>
Date: 9 Mar 2005 13:10:55 -0800
Message-ID: <1110402655.581753.139650@f14g2000cwb.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:10:55 CST