Re: Oracle 9i query results differ from Oracle 8i! Is Oracle 9i reliable when using complex queries with analytic functions? This is very serious question!

From: Sergey Adamenko <wadamenko_wusenet_at_wukr.net>
Date: Fri, 4 Mar 2005 21:39:52 +0200
Message-ID: <d0adk7$24ed$1@news.dg.net.ua>

Here is more simplified query for the problem:

SELECT
  dept.dname,
  rlp_join.rlp_name,
  rlp_join.s_sal
FROM (SELECT

        dept.dname,
        rlp.dname rlp_name,
        rlp.s_sal
      FROM (SELECT 
              dept.dname,
              SUM (emp.sal) s_sal
            FROM dept,
              emp
            WHERE dept.deptno = emp.deptno
            GROUP BY ROLLUP (dept.dname)) rlp,
        dept
      WHERE dept.dname = rlp.dname) rlp_join,

  dept
WHERE
  dept.dname = rlp_join.dname(+) AND
  rlp_join.dname IS NULL

Best regards,
Sergey Adamenko.
Senior Oracle DBA.
Kyiv, Ukraine.
E-mail: wadamenko_wusenet_at_wukr.net (remove 'w' from E-mail)   Received on Fri Mar 04 2005 - 13:39:52 CST