[oracle] union all 을 이용하여 두개의 테이블 조회

select 
    PHONE 
from ( 
        select 
            replace(replace(PHONE,'-',''),' ', '') as PHONE 
        from 
            TB_SIGNATURE 
        where 
            RMV_YN = 'Y' 
 
        union all 
 
        select 
            replace(replace(PHONE,'-',''),' ', '') as PHONE 
        from 
            TB_SHOT 
        where 
            RMV_YN = 'Y' 
    ) A 
group by 
    PHONE having isNull(PHONE,'') != '' 
order by 
    PHONE