①
select
a.column1,
b.column1
from a, b
where a.column1 = decode(b.column1, null, a.column1, b.column1);
②
select
a.column1,
b.column1
from a, b
where instr(decode(b.column1, null, a.column1, b.column1), a.column1) > 0;
①
select
a.column1,
b.column1
from a, b
where a.column1 = decode(b.column1, null, a.column1, b.column1);
②
select
a.column1,
b.column1
from a, b
where instr(decode(b.column1, null, a.column1, b.column1), a.column1) > 0;