Why I can not using alias in 11G
Date: Sun, 7 Feb 2010 17:16:48 -0800 (PST)
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?
Havel Received on Sun Feb 07 2010 - 19:16:48 CST