需要oracle9i支持,所说的版本是Oracle服务器的版本 版本查看:select * from v$version; 楼主的需求可这样实现(对oracle7.3以上版本有效):select A.x1, A.x2, A.a1, B.b1 from A , B where A.x1 = B.x1 and A.x2 = B.x2 union select A.x1, A.x2, A.a1, B.b1 from A , B where A.x1 = B.x1(+) and A.x2 = B.x2(+) union select A.x1, A.x2, A.a1, B.b1 from A , B where A.x1(+) = B.x1 and A.x2(+) = B.x2
如何知道Oracle的版本?
这个Oracle9i是PL/SQL的版本还是Oracle服务器的版本?
版本查看:select * from v$version;
楼主的需求可这样实现(对oracle7.3以上版本有效):select A.x1, A.x2, A.a1, B.b1
from A , B
where A.x1 = B.x1 and A.x2 = B.x2
union
select A.x1, A.x2, A.a1, B.b1
from A , B
where A.x1 = B.x1(+) and A.x2 = B.x2(+)
union
select A.x1, A.x2, A.a1, B.b1
from A , B
where A.x1(+) = B.x1 and A.x2(+) = B.x2