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:
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