with tt as (
select '1' as a, '2' as b, 12 as c from dual
union all
select '1' as a, null as b, 12 as c from dual
)
select * from tt;
with tt as (
select '1' as a, '2' as b, 12 as c from dual
union all
select '1' as a, null as b, 12 as c from dual
)
select * from tt;