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