1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
CREATE OR REPLACE FUNCTION stripped_string ( string_in IN VARCHAR2)
RETURN VARCHAR2
IS
string_out NVARCHAR2(3276):=string_in;
BEGIN
string_out:=replace(string_out,'é','é');
string_out:=replace(string_out,'ä', 'ä');
string_out:=replace(string_out,'è', 'è');
string_out:=replace(string_out,'Ã ', 'à');
string_out:=replace(string_out,'ç', 'ç');
string_out:=replace(string_out,'ô', 'ô');
string_out:=replace(string_out,'ù', 'ù');
string_out:=replace(string_out,'ï', 'ï');
string_out:=replace(string_out,'ë', 'ë');
string_out:=replace(string_out,'Ã?', 'É');
string_out:=replace(string_out,'ô', 'ô');
string_out:=replace(string_out,'ê', 'ê');
string_out:=replace(string_out,'û', 'û');
string_out:=replace(string_out,'î', 'î');
string_out:=replace(string_out,'â', 'â');
RETURN string_out;
END stripped_string; |
