UPDATE EMP
SET EMP_KANA_NAME = TRIM(EMP_KANA_NAME, "_");
SELECT
EMP_CODE AS CODE,
"'"||EMP_KANA_NAME||"'" AS KANA_NAME
FROM EMP
ORDER BY CODE DESC;