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 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53
|
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.3.0
SQL>
SQL> With Data As (
2 Select 'Chemise16' as a, 'Vrt' as b, 'Vert' as c from dual union all
3 Select 'Chemise17', 'Blenc', 'Blanc' from dual union all
4 Select 'Pantalon1', 'Rouge', 'Rouge' from dual union all
5 Select 'Pantalon11', 'Gris souris', 'Gris' from dual union all
6 Select 'Pantalon14', 'Rouge brique', 'Rouge' from dual union all
7 Select 'Pantalon6', 'Gris bleu', 'Bleu' from dual union all
8 Select 'Pantalon6', 'Gris bleu', 'Gris' from dual union all
9 Select 'Pantalon7', 'Vert', 'Vert' from dual union all
10 Select 'Pull13', 'bleue', 'Bleu' from dual union all
11 Select 'Pull15', 'Marron', 'Marron' from dual union all
12 Select 'Pull4', 'Jaune paille', 'Jaune' from dual union all
13 Select 'Pull9', 'blanc', 'Blanc' from dual union all
14 Select 'Robe10', 'Blanche', 'Blanc' from dual union all
15 Select 'Robe12', 'rose', 'Rose' from dual union all
16 Select 'Robe2', 'Vert d''eau', 'Vert' from dual union all
17 Select 'Robe3', 'Viol.', 'Violet' from dual union all
18 Select 'Robe5', 'Verte', 'Vert' from dual union all
19 Select 'Robe8', 'Rouge', 'Rouge' from dual
20 )
21 Select a, b, c,
22 F_INFERENCE_BASIQUE(b,c) FintB,
23 F_INFERENCE_BASIQUE(Upper(b),Upper(c)) Fintb_Upp,
24 utl_match.jaro_winkler(b,c)jar
25 from Data
26 /
A B C FINTB FINTB_UPP JAR
---------- ------------ ------ ---------- ---------- ----------
Chemise16 Vrt Vert 3 3 0,925
Chemise17 Blenc Blanc 4 4 0,89333333
Pantalon1 Rouge Rouge 5 5 1
Pantalon11 Gris souris Gris 4 4 0,87272727
Pantalon14 Rouge brique Rouge 5 5 0,88333333
Pantalon6 Gris bleu Bleu 3 4 0
Pantalon6 Gris bleu Gris 4 4 0,88888888
Pantalon7 Vert Vert 4 4 1
Pull13 bleue Bleu 3 4 0,78333333
Pull15 Marron Marron 6 6 1
Pull4 Jaune paille Jaune 5 5 0,88333333
Pull9 blanc Blanc 4 5 0,86666666
Robe10 Blanche Blanc 5 5 0,94285714
Robe12 rose Rose 3 4 0,83333333
Robe2 Vert d'eau Vert 4 4 0,88
Robe3 Viol. Violet 4 4 0,89333333
Robe5 Verte Vert 4 4 0,96
Robe8 Rouge Rouge 5 5 1
18 rows selected
SQL> |
Partager