Oracle11g下ORA-01417的解决办法

--创建测试表create table cux_test_1(   a1  number,   b1  varchar2(100));-------create table cux_test_2(   a2  number,   b2  varchar2(100));-------create table cux_test_3(   a3  number,   b3  varchar2(100));--drop table cux_test_3;--select * from cux_test_3;insert into cux_test_1(a1,b1) values (1,'a');insert into cux_test_2(a2,b2) values (2,'b');insert into cux_test_3(a3,b3) values (3,'c');--12c运行没有问题，11g运行会报错ORA-01417select *from cux_test_1 a,cux_test_2 b,cux_test_3 cwhere a.a1 = b.a2(+)and c.a3 = b.a2(+);----------------------11g下需做如下修改select *  from (select a.a1, a.b1, c.a3, c.b3          from cux_test_1 a, cux_test_3 c) x,       cux_test_2 b where x.a1 = b.a2(+) and x.a3 = b.a2(+);