部分版本的Oracle在使用2层及以上嵌套查询(子查询)时,存在不识别子查询中列明的BUG。
测试语句如下:
select (select * from (select a.dummy from dual a where a.dummy = dual.dummy)) from dual;
若当前使用的版本存在该BUG,会提示"dual.dummy"列"invalid identifier"。
官方给出的说明是:
that was a bug.it works in none of the terminal releases of 9i, 10g, or 11g .