1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
|
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
Connected as mni
SQL>
SQL> With Data as (
2 Select 'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÑÒÓÔÕÖØÙÚÛÜÝàáâãäåæçèéêëìíîïñòóôõöøùúûüý' as nom from dual
3 )
4 Select regexp_replace(
5 regexp_replace(
6 regexp_replace(
7 regexp_replace(
8 regexp_replace(
9 regexp_replace(
10 regexp_replace(
11 regexp_replace(
12 regexp_replace(Upper(nom), '[[=A=]]','A')
13 ,'[[=E=]]','E')
14 ,'[[=N=]]','N')
15 ,'[[=O=]]','O')
16 ,'[[=U=]]','U')
17 ,'[[=I=]]','I')
18 ,'[[=C=]]','C')
19 ,'[[=Y=]]','Y')
20 ,'[[=Æ=]]','?') Trans
21 From Data
22 /
TRANS
--------------------------------------------------------
AAAAAA?CEEEEIIIINOOOOOOUUUUYAAAAAA?CEEEEIIIINOOOOOOUUUUY
SQL> |
Partager