oracle的视图能否实现像sql server的视图一样的左联接或右联接或full

Question

a = b(+) 左连接
b(+) = b 右连接

Answer 1

http://www.oreilly.com/catalog/orsqlpluspr2/chapter/ch01.html
http://www.zdnet.com.cn/developer/tech/story/0,2000081602,39049303,00.htm
http://expert.csdn.net/Expert/topic/1921/1921553.xml?temp=.6813471

Answer 2

但full outter joing好像只有9i支持，而我的是8i啊

Answer 3

full连接
select * from a,b where a.id(+)=b.id
union
select * from a,b where a.id=b.id(+)左连接
select * from a,b where a.id=b.id(+)右连接
select * from a,b where a.id(+)=b.id