SELECT * FROM B
WHERE A_ID IN ( SELECT A_ID FROM A)
UNION
(
SELECT A_ID , '' , '' FROM A
MINUS
SELECT A_ID , '' , '' FROM B
)
WHERE A_ID IN ( SELECT A_ID FROM A)
UNION
(
SELECT A_ID , '' , '' FROM A
MINUS
SELECT A_ID , '' , '' FROM B
)
from A,B
where A.a_id=B.a_id(+)
order by A.a_id
on a.a_id = b.a_id
order by a.a_id ;