UPDATE
    EMP
SET
    EMP_KANA_NAME = REPLACE(EMP_KANA_NAME, '_', '');

SELECT
    EMP_CODE AS CODE,
    EMP_KANA_NAME AS KANA_NAME
FROM
    EMP
ORDER BY
    EMP_CODE DESC;