Why I can not using alias in 11G

From: Havel Zhang <havel.zhang_at_gmail.com>
Date: Sun, 7 Feb 2010 17:16:48 -0800 (PST)
Message-ID: <cfb392b4-84c4-4a72-804e-9d9f781bf0a4_at_m31g2000yqd.googlegroups.com>

hi all:

     I found some query will cause ORA-00918 error(column ambiguously defined) in 11G, but running well in 10G.

     I give an example:

---

                       select
 
supplier_code,dept_code,local_name,english_name
                       from
                            supplier a inner join
                                              (select supplier_code s,
                                                         dept_code d,
                                                         max(rowid) r
                                               from supplier
                                               group by
supplier_code,dept_code
                                              ) b on a.supplier_code =

b.s and a.dept_code = b.d and a.rowid = b.r

---

       The query above can running well in 10G, but will cause an error on 11G, of course, I can rewrite the query, but who can tell me why, 11G have new feature ? have any parameter to solve this problem?

Thank you.

Havel Received on Sun Feb 07 2010 - 19:16:48 CST