with t1(id, v) as (
select 1, 'aaa' from dual union all
select 2, 'bbb' from dual union all
select 3, 'ccc' from dual
), t2(id, v) as (
select 1, 'aaw' from dual union all
select 4, 'bbv' from dual union all
select 5, 'ccb' from dual
)

select t1.*, t2.*
from t1 full join t2 on (t1.id = t2.id)
where t1.id is null or t2.id is null

select t1.*, t2.*
from t1 full join t2 using (id)

ORA-25154: column part of USING clause cannot have qualifier


select *
from t1 full join t2 using (id)