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
| SELECT XMLROOT (
XMLELEMENT ( "ROOT"
,XMLELEMENT ( "regions"
,XMLELEMENT ( "region" , XMLATTRIBUTES ( ls_region AS "name" )
,XMLELEMENT ( "patient_all"
,XMLAGG (XMLELEMENT ( "patient"
,XMLELEMENT ( "FAY_SEQ_NO",a)
,XMLELEMENT ( "REF_NO",b)
,XMLELEMENT ( "NAT",c)
,XMLELEMENT ( "Nom",d)
,XMLELEMENT ( "PRENOM",e)
,XMLELEMENT ( "DAT_NAISSANCE",f)
,XMLELEMENT ( "SEX",g)
,XMLELEMENT ( "PHONE_NO",h)
,XMLELEMENT ( "GSM",i)
,XMLELEMENT ( "POURCENT_HANDIC",j)
,XMLELEMENT ( "BIM",k)
,XMLELEMENT ( "STT_SEQ_NO",l)
,XMLELEMENT ( "HOUSE_NO",m)
,XMLELEMENT ( "BOX",n)
,XMLELEMENT ( "COMMUNE",o)
,XMLELEMENT ( "CP",p)
,XMLELEMENT ( "PAYS",q)
,XMLELEMENT ( "MUT_SEQ_NO",r)
,XMLELEMENT ( "MUTUELLE",s)
,XMLELEMENT ( "DOC_SEQ_NO",t)
,XMLELEMENT ( "SERV_SEQ_NO",u)
,XMLELEMENT ( "SERVICE",v)
)
)
)
)
)
,XMLELEMENT ( "streets_all"
,XMLAGG (XMLELEMENT ( "street"
,XMLELEMENT ( "STREET_SEQ_NO",aa)
,XMLELEMENT ( "NOM_RUE",bb)
,XMLELEMENT ( "COMMUNE_SEQ_NO",cc)
)
)
)
), version '1.0" encoding="UTF-8'
)
INTO lv_xml
from tmp_new_pat; |
Partager