1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| select extractValue(X,'/Noeud1') as n1
, extractValue(X,'/Noeud2') as n2
, extractValue(X,'/Noeud3') as n3
, extractValue(X,'/Noeud4') as n4
, extractValue(X,'/Noeud5') as n5
, extractValue(X,'/Noeud6') as n6
, extractValue(X,'/Noeud7') as n7
from A
intersect
select extractValue(X,'/Noeud1') as n1
, extractValue(X,'/Noeud2') as n2
, extractValue(X,'/Noeud3') as n3
, extractValue(X,'/Noeud4') as n4
, extractValue(X,'/Noeud5') as n5
, extractValue(X,'/Noeud6') as n6
, extractValue(X,'/Noeud7') as n7
from B; |
Partager