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

From: Brian <brian_at_databaseknowledge.com>
Date: 9 Mar 2005 14:31:45 -0800
Message-ID: <1110407505.646093.171370@o13g2000cwo.googlegroups.com>

Google seems to be having issues...here's the query again:

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 - 16:31:45 CST