Ajuda para montar essa Select

[leandrolbsParticipante]

tem que ser a mesma quantidade de colunas e o tipo tbm;

Errado:

select CAST('23' as number(2)) from dual
union all
select CAST('AA' as char(2)) from dual


Ok:

select to_char(CAST('23' as number(2))) from dual
union all
select CAST('23' as char(2)) from dual