with non_right_bar as
(select 
 EMP_CODE
 ,rtrim(EMP_KANA_NAME,'_') as right_kana
from EMP
)
select 
 EMP_CODE as CODE
 ,''''||ltrim(right_kana,'_')||'''' as KANA_NAME
from non_right_bar
order by EMP_CODE desc;