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; |
Partager