Ready to be published? LXer is read by around 350,000 individuals each month, and is an excellent place for you to publish your ideas, thoughts, reviews, complaints, etc. Do you have something to say to the Linux community?
Learn to “shred" XML documents into relational tables through annotated XML schema decomposition or XMLTABLE Decomposition. This article reviews the two methods of decomposing XML data including, how to use the XMLTABLE function for decomposition.