oracle 全外联接

1.

select a.code , a.name , b.code , b.name
from a,b
where a.code = b.code(+)
union
select a.code , a.name , b.code , b.name
from a,b
where a.code(+) = b.code

2.

select a.code ,a.name,b.code,b.name

from table1 a full out join table2 b on a.code = b.code