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
|
with COMPETENCE as (Select 1 idCompetence, 'Competence_1' descriptif, 1 domComp From dual union all
Select 2 idCompetence, 'Competence_2' descriptif, 1 domComp From dual union all
Select 3 idCompetence, 'Competence_3' descriptif, 2 domComp From dual union all
Select 4 idCompetence, 'Competence_4' descriptif, 2 domComp From dual union all
Select 5 idCompetence, 'Competence_5' descriptif, 2 domComp From dual),
DOMAINE as (Select 1 idDomaine, 'Domaine_1' descriptif From Dual Union All
Select 2 idDomaine, 'Domaine_2' descriptif From Dual)
Select XMLSERIALIZE(CONTENT XMLELEMENT(
NAME "domaine",
XMLATTRIBUTES(
D.idDomaine "name"
),
XMLFOREST(
d.descriptif "description"
),
(
SELECT XMLAGG(
XMLELEMENT(
NAME "competence",
XMLATTRIBUTES(
c.idCompetence "name"
),
XMLFOREST(
c.descriptif "description"
)
)
)
FROM competence c
WHERE C.domcomp = D.idDomaine
)
))
From DOMAINE D |
Partager