Oracle 12cで文字列の全角文字を半角文字に変換
環境
Oracle 12.2.0.1.0
SQL構文
SELECT
TO_SINGLE_BYTE('５６７８９ＸＹＺＫ＠！”＃＄％＆') AS RESULT
FROM
DUAL;
SELECT
TO_SINGLE_BYTE('５６７８９ＸＹＺＫ＠！”＃＄％＆') AS RESULT
FROM
DUAL;
SELECT
TO_SINGLE_BYTE('５６７８９ＸＹＺＫ＠！”＃＄％＆') AS RESULT
FROM
DUAL;
実行結果
RESULT
56789XYZK@!"#$%&
RESULT
56789XYZK@!"#$%&
RESULT 56789XYZK@!"#$%&