[oracle] ascii

Published: 2020-04-16 by mascaradee

• Categories:
• oracle 14

• Tags:
• ascii 1
• chr 1

• ASCII(문자 혹은 숫자)
• CHR(숫자)

ASCII(문자 혹은 숫자)

SELECT ASCII('A') FROM DUAL;
-- 65
SELECT ASCII('a') FROM DUAL;
-- 97
SELECT ASCII('ㄱ') FROM DUAL;
-- 14910641

CHR(숫자)

숫자(아스키코드값) -> 문자

SELECT CHR(65) FROM DUAL;
-- A
SELECT CHR(97) FROM DUAL;
-- a
SELECT CHR(14910641) FROM DUAL;
-- ㄱ