Quel SGBD choisir : Oracle ou Microsoft SQL-Server ?

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
  
SQL> SELECT     * 
  2  FROM               Carte 
  3  ; 
PARIS                            CLERMONT-FERRAND                        422 
PARIS                            LYON                                    463 
CLERMONT-FERRAND                 PARIS                                   422 
CLERMONT-FERRAND                 LYON                                    206 
CLERMONT-FERRAND                 MONTPELLIER                             335 
CLERMONT-FERRAND                 TOULOUSE                                375 
LYON                             PARIS                                   463 
LYON                             CLERMONT-FERRAND                        205 
LYON                             MONTPELLIER                             303 
MONTPELLIER                      CLERMONT-FERRAND                        332 
MONTPELLIER                      LYON                                    301 
MONTPELLIER                      TOULOUSE                                241 
TOULOUSE                         CLERMONT-FERRAND                        374 
TOULOUSE                         MONTPELLIER                             242 
  
14 ligne(s) sÚlectionnÚe(s). 
  
SQL> WITH T AS 
  2  ( 
  3  SELECT     CONNECT_BY_ROOT depart || SYS_CONNECT_BY_PATH (destination, 
  4             SYS_CONNECT_BY_PATH (km, '+') AS x 
  5  FROM               Carte 
  6  WHERE      CONNECT_BY_ROOT depart = 'PARIS' 
  7  AND                destination = 'TOULOUSE' 
  8  CONNECT BY NOCYCLE PRIOR destination = depart 
  9  AND                destination <> CONNECT_BY_ROOT depart 
 10  ) 
 11  SELECT     CAST (t AS VARCHAR(48)), 
 12             CAST (x AS VARCHAR(16)), 
 13             CAST (SUM (CASE SUBSTR(x, LEVEL, 1) 
 14             WHEN '+' 
 15             THEN REGEXP_SUBSTR (SUBSTR (x, LEVEL, LENGTH(x)), '^[+][0-9 
 16             END) AS VARCHAR(8) ) 
 17  FROM               T 
 18  GROUP BY   t, 
 19             x 
 20  CONNECT BY  x = CONNECT_BY_ROOT x 
 21  AND                LEVEL <= LENGTH(x) 
 22  ; 
PARIS,CLERMONT-FERRAND,LYON,MONTPELLIER,TOULOUSE +422+206+303+241 1172 
PARIS,LYON,MONTPELLIER,CLERMONT-FERRAND,TOULOUSE +463+303+332+375 1473 
PARIS,CLERMONT-FERRAND,MONTPELLIER,TOULOUSE      +422+335+241     998 
PARIS,LYON,CLERMONT-FERRAND,MONTPELLIER,TOULOUSE +463+205+335+241 1244 
PARIS,LYON,MONTPELLIER,TOULOUSE                  +463+303+241     1007 
PARIS,CLERMONT-FERRAND,TOULOUSE                  +422+375         797 
PARIS,LYON,CLERMONT-FERRAND,TOULOUSE             +463+205+375     1043 
  
7 ligne(s) sÚlectionnÚe(s).