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