select EMP_CODE as 'CODE', trim(EMP_KANA_NAME, '_') as 'KANA_NAME'
from EMP
order by CODE asc
;