티스토리 뷰

카테고리 없음

[ORACLE] ASCII 함수

번쩍코딩 2024. 5. 28. 15:37 
SELECT 
	ASCII('A') AS '대문자'
   ,ASCII('a') AS '소문자'
FROM DUAL;​
ASCII 함수 사용법 

 

ASCII(문자)

 

문자를 ASCII코드로 변환하는 함수이다.

 

 

 

ASCII 코드 표
10진수 문자 10진수 문자
0 NUL, NULL(Ctrl + @) 64 @
1 SOH, Start of Header(Ctrl + A) 65 A
2 STX, Start of Text(Ctrl + B) 66 B
3 ETX, End of Text(Ctrl + C) 67 C
4 EOT, End of Transmission(Ctrl + D) 68 D
5 ENQ, Enquiry(Ctrl + E) 69 E
6 ACK, Acknowledgment(Ctrl + F) 70 F
7 BEL, Bell(Ctrl + G) 71 G
8 BS, Backspace(Ctrl + H) 72 H
9 HT, Horizontal Tab(Ctrl + I) 73 I
10 LF, Line feed(Ctrl + J) 74 J
11 VT, Vertical Tab(Ctrl + K) 75 K
12 FF, Form feed(Ctrl + L) 76 L
13 CR, Carriage return(Ctrl + M) 77 M
14 SO, Shift Out(Ctrl + N) 78 N
15 SI, Shift In(Ctrl + O) 79 O
16 DLE, Data Link Escape(Ctrl + P) 80 P
17 DC1, Device Control 1(Ctrl + Q) 81 Q
18 DC2, Device Control 2(Ctrl + R) 82 R
19 DC3, Device Control 3(Ctrl + S) 83 S
20 DC4, Device Control 4(Ctrl + T) 84 T
21 NAK, Negative Ack.(Ctrl + U) 85 U
22 SYN, Synchronous idle(Ctrl + V) 86 V
23 ETB, End of Trnas, Block(Ctrl + W) 87 W
24 CAN, Cancel(Ctrl + X) 88 X
25 EM, End of Medium(Ctrl + Y) 89 Y
26 SUB, Substitute(Ctrl + Z) 90 Z
27 ESC, Escape(Ctrl + [) 91 [
28 FS, File Separator(Ctrl + \) 92 \
29 GS, Group Separator(Ctrl + ]) 93 ]
30 RS, Record Separator(Ctrl + ^) 94 ^
31 US, Unit Separator(Ctrl + _) 95 _
32 SP, Space 96 '
33 !  97 a
34 "  98 b
35 # 99 c
36 $  100 d
37 %  101 e
38 &  102 f
39 '  103 g
40 ( 104 h
41 )  105 i
42 *  106 j
43 + 107 k
44 , 108 l
45 -  109 m
46 .  110 n
47  / 111 o
48  0 112 p
49  1 113 q
50  2 114 r
51  3 115 s
52  4 116 t
53  5 117 u
54  6 118 v
55  7 119 w
56  8 120 x
57  9 121 y
58 :  122 z
59 ;  123 {
60 <  124 |
61 =  125 }
62 >  126 ~
63 ?  127 DEL, Del