Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

XMLELEMENT grouping a set of data

User_POZ94Jun 7 2020 — edited Jun 11 2020

need your help in resolving below issue :

Below XML Structure we are able to generate where the data is linear with no grouping with respect to the Models.

however we need the output in below format by grouping the model attributes with respect to model number

we created below SQL query to generate the 1st XML but unable to generate the desired 2nd xml

Table data :

pastedImage_0.png

PLease help us ASAP.

regards, Sam
This post has been answered by Stew Ashton on Jun 7 2020
Jump to Answer
Comments
Post Details
Added on Jun 7 2020
#xml
3 comments
896 views