Application of Replace function in Oracle

The Replace function uses the following:

Replace (' string to be changed ', ' replaced string ', ' replace string ')

The Chr () function in Oracle

CHR ()--converts ASCII code to characters
Grammar
CHR (Number_code)
Example
Select CHR from dual; --return ' t '

Several commonly used Chr () functions:
Chr (9)--Tab
Chr (10)--line break
Chr (13)--carriage return
Chr (32)--whitespace
Chr (34)--double quote "" "

Example: replace (' 111<br/>333444 ', Chr (13) | | Chr (10), ')

CHR () has a corresponding function ASCII (), which can achieve the opposite effect.

ASCII ()--Converts a character to an ASCII code

Syntax ASCII (single_character)

Example Select ASCII (' t ') from dual; --Return 116

ASCII table

Dec	Hex	Oct	Char	Description
0	0	000		Null
1	1	001		Start of heading
2	2	002		Start of text
3	3	003		End of text
4	4	004		End of transmission
5	5	005		Enquiry
6	6	006		Acknowledge
7	7	007		Bell
8	8	010		Backspace
9	9	011		Horizontal tab
10	A	012		New Line
11	B	013		Vertical tab
12	C	014		New Page
13	D	015		Carriage return
14	E	016		Shift out
15	F	017		Shift in
16	10	020		Data Link Escape
17	11	021		Device Control 1
18	12	022		Device Control 2
19	13	023		Device Control 3
20	14	024		Device Control 4
21st	15	025		Negative acknowledge
22	16	026		Synchronous idle
23	17	12V		End of trans. block
24	18	030		Cancel
25	19	031		End of medium
26	1 A	032		Substitute
27	1 b	033		Escape
28	1C	034		File separator
29	1D	035		Group Separator
30	1E	13W		Record separator
31	1F	037		Unit separator
32	20	040		Space
33	21st	041	!
34	22	042	"
35	23	043	#
36	24	044	$
37	25	045	%
38	26	046	&
39	27	047	‘
40	28	050	(
41	29	051	)
42	2 A	052	*
43	2 b	053	+
44	2 C	054	,
45	The	15T	-
46	2E	15W	.
47	2F	15V	/
48	30	060	0
49	31	061	1
50	32	062	2
51	33	063	3
52	34	064	4
53	35	065	5
54	36	16W	6
55	37	067	7
56	38	070	8
57	39	071	9
58	3 A	072	:
59	3 b	073	;
60	3C	074	<
61	3D	075	=
62	3E	076	>
63	3F	077	?
64	40	100	@
65	41	101	A
66	42	102	B
67	43	103	C
68	44	104	D
69	45	105	E
70	46	106	F
71	47	107	G
72	48	110	H
73	49	111	I
74	4 A	112	J
75	4 b	113	K
76	4C	114	L
77	4D	115	M
78	4E	116	N
79	4F	117	O
80	50	120	P
81	51	121	Q
82	52	122	R
83	53	123	S
84	54	124	T
85	55	125	U
86	56	126	V
87	57	127	W
88	58	130	X
89	59	131	Y
90	5 A	132	Z
91	5B	133	[
92	5C	134	\
93	5D	135	]
94	5E	136	^
95	5F	137	_
96	60	140	`
97	61	141	A
98	62	142	B
99	63	143	C
100	64	144	D
101	65	145	E
102	66	146	F
103	67	147	G
104	68	150	H
105	69	151	I
106	6A	152	J
107	6B	153	K
108	6C	154	L
109	6D	155	M
110	6E	156	N
111	6F	157	O
112	70	160	P
113	71	161	Q
114	72	162	R
115	73	163	S
116	74	164	T
117	75	165	U
118	76	166	V
119	77	167	W
120	78	170	X
121	79	171	Y
122	7A	172	Z
123	7B	173	{
124	7C	174	|
125	7D	175	}
126	7E	176	~
127	7F	177	Del