Chr () and ASCII () functions in Oracle (attached: characters commonly used and ASCII table)
keywords: chr ()
Chr () function action: Special handling of "special" characters
The corresponding loadline and special characters can be queried in Plsql
Chr () Function Example: select CHR from dual; ASCII () Function Example: Select ASCII (' & ') from dual;
For example, why is "&" a special character in Oracle? After the search, finally revealed the answer: the original & this character is used in Oracle SQL statements or stored procedures to specify that it is followed by the execution of the variables you enter. For example: SELECT * from &AAA; the system prompts you to assign a value when executing this statement. Or, for example, insert into Test (Col1,col2,col3,type) VALUES (0,0,0, ' &type ') when executing this statement in PL/SQL developer A variables prompt box will pop up asking you to enter the variable ' type ' value. And if executed: INSERT INTO Test (Col1,col2,col3,type) VALUES (0,0,0,CHR (38) | | Type '), it will obediently insert this data into the table. This, all doubts are cloud open fog scattered liao! ~
When special characters are processed separately (add ' or Chr (ASCII)), then use | | Connect other characters.
The following is a common character and ASCII table for reference:
The first part from 00H to 1FH a total of 32, generally used for communication or as a control, some characters can be displayed on the screen, some will not be displayed on the screen, but can see its effects (such as newline characters, return characters).
The second part is from 20H to 7FH a total of 96, these 95 characters are used to denote Arabic numerals, English letters and the bottom line, brackets and other symbols can be displayed on the screen. As the following table:
ASCII code |
character |
|
ASCII code |
character |
|
ASCII |
character |
|
ASCII code |
character |
Decimal |
16 Rounding |
|
Decimal |
16 Rounding |
|
Decimal |
16 Rounding |
|
Decimal |
16 Rounding |
032 |
20 |
|
|
056 |
38 |
8 |
|
080 |
50 |
P |
|
104 |
68 |
H |
033 |
21st |
! |
|
057 |
39 |
9 |
|
081 |
51 |
Q |
|
105 |
69 |
I |
034 |
22 |
" |
|
058 |
3 A |
: |
|
082 |
52 |
R |
|
106 |
6A |
J |
035 |
23 |
# |
|
059 |
3 b |
; |
|
083 |
53 |
S |
|
107 |
6B |
K |
036 |
24 |
$ |
|
060 |
3C |
< |
|
084 |
54 |
T |
|
108 |
6C |
L |
037 |
25 |
% |
|
061 |
3D |
= |
|
085 |
55 |
U |
|
109 |
6D |
M |
038 |
26 |
& |
|
062 |
3E |
> |
|
18W |
56 |
V |
|
110 |
6E |
N |
039 |
27 |
‘ |
|
063 |
3F |
? |
|
18V |
57 |
W |
|
111 |
6F |
O |
040 |
28 |
( |
|
064 |
40 |
@ |
|
088 |
58 |
X |
|
112 |
70 |
P |
041 |
29 |
) |
|
065 |
41 |
A |
|
089 |
59 |
Y |
|
113 |
71 |
Q |
042 |
2 A |
* |
|
16W |
42 |
B |
|
090 |
5 A |
Z |
|
114 |
72 |
R |
043 |
2 b |
+ |
|
16V |
43 |
C |
|
091 |
5B |
[ |
|
115 |
73 |
S |
044 |
2 C |
, |
|
068 |
44 |
D |
|
092 |
5C |
\ |
|
116 |
74 |
T |
24w |
The |
- |
|
16X |
45 |
E |
|
093 |
5D |
] |
|
117 |
75 |
U |
046 |
2E |
. |
|
070 |
46 |
F |
|
094 |
5E |
^ |
|
118 |
76 |
V |
047 |
2F |
/ |
|
071 |
47 |
G |
|
095 |
5F |
_ |
|
119 |
77 |
W |
048 |
30 |
0 |
|
072 |
48 |
H |
|
096 |
60 |
` |
|
120 |
78 |
X |
049 |
31 |
1 |
|
073 |
49 |
I |
|
097 |
61 |
A |
|
121 |
79 |
Y |
050 |
32 |
2 |
|
074 |
4 A |
J |
|
098 |
62 |
B |
|
122 |
7A |
Z |
051 |
33 |
3 |
|
075 |
4 b |
K |
|
099 |
63 |
C |
|
123 |
7B |
{ |
052 |
34 |
4 |
|
076 |
4C |
L |
|
100 |
64 |
D |
|
124 |
7C |
| |
053 |
35 |
5 |
|
077 |
4D |
M |
|
101 |
65 |
E |
|
125 |
7D |
} |
054 |
36 |
6 |
|
078 |
4E |
N |
|
102 |
66 |
F |
|
126 |
7E |
~ |
055 |
37 |
7 |
|
079 |
4F |
O |
|
103 |
67 |
G |
|
127 |
7F |
|
The third part from 80H to 0FFH a total of 128 characters, commonly referred to as "extended character", these 128 expansion characters are developed by IBM, not the standard ASCII code. These characters are used to denote lines, phonetic symbols, and other non-English-language letters in Europe.
ESC key |
Vk_escape (27) |
Enter |
Vk_return (13) |
TAB key |
Vk_tab (9) |
Caps Lock key |
Vk_capital (20) |
Shift key |
Vk_shift () |
CTRL key |
Vk_control (17) |
ALT key |
Vk_menu (18) |
Space key |
Vk_space (/32) |
Backspace key |
Vk_back (8) |
Left logo key |
Vk_lwin (91) |
Right logo key |
Vk_lwin (92) |
Right-click Shortcut keys |
Vk_apps (93) |
Insert key |
Vk_insert (45) |
Home key |
Vk_home (36) |
Page up |
Vk_prior (33) |
PageDown |
Vk_next (34) |
End key |
Vk_end (35) |
Delete key |
Vk_delete (46) |
Arrow keys (←) |
Vk_left (37) |
Arrow keys (↑) |
VK_UP (38) |
arrow keys (→) |
Vk_right (39) |
Arrow keys (↓) |
Vk_down (40) |
F1 Key |
VK_F1 (112) |
F2 Key |
VK_F2 (113) |
F3 Key |
VK_F3 (114) |
F4 Key |
VK_F4 (115) |
F5 Key |
VK_F5 (116) |
F6 Key |
VK_F6 (117) |
F7 Key |
VK_F7 (118) |
F8 Key |
Vk_f8 (119) |
F9 Key |
VK_F9 (120) |
F10 Key |
VK_F10 (121) |
F11 Key |
VK_F11 (122) |
F12 Key |
VK_F12 (123) |
Num Lock key |
Vk_numlock (144) |
Numpad 0 |
VK_NUMPAD0 (96) |
Numpad 1 |
VK_NUMPAD0 (97) |
Numpad 2 |
VK_NUMPAD0 (98) |
Numpad 3 |
VK_NUMPAD0 (99) |
Numpad 4 |
VK_NUMPAD0 (100) |
Numpad 5 |
VK_NUMPAD0 (101) |
Numpad 6 |
VK_NUMPAD0 (102) |
Numpad 7 |
VK_NUMPAD0 (103) |
Numpad 8 |
VK_NUMPAD0 (104) |
Numpad 9 |
VK_NUMPAD0 (105) |
keypad. |
Vk_decimal (110) |
Small keyboard * |
Vk_multiply (106) |
Keypad + |
Vk_multiply (107) |
Small keyboard- |
Vk_subtract (109) |
Keypad/ |
Vk_divide (111) |
Pause Break key |
Vk_pause (19) |
Scroll Lock key |
Vk_scroll (145) |
|
|
|
|
Chr () and ASCII () functions in Oracle (attached: characters commonly used and ASCII table)