Article:		Storing XML in Relational Databases
Subject:		XML document to be decomposed into a collection of xml subdocuments, using XSLT ?
Date:		2003-08-26 09:36:11
From:		punam verma
Thanks this article is very informative . on page 1 of this article point 2 uve mentioned -'2. ...the XML document can be decomposed into a collection of "flat" subdocuments, using XSLT.' I have an Invoice Xml file it needs to be split into Customer,InvoiceDetails, Line Item xml files. Question is how do i perform this thru xslt . I need 3 separate files in 1 step . Also pls could u give me some links where I could find solutions to queries similar to mine . thanks in advance .

Previous Message

Next Message

• XML document to be decomposed into a collection of xml subdocuments, using XSLT ?
  2003-08-28 15:40:23 punam verma
  
  This can be done by
  For further reading/example visit http://www.w3.org/TR/xslt11/#multiple-output
  
  
  

• XML document to be decomposed into a collection of xml subdocuments, using XSLT ?
  2003-08-26 19:42:06 Igor Dayen
  
  Thank you for feedback.
  You may condider creating separate stylesheets
  for Customer,InvoiceDetails, etc. to be applied
  to the input document Invoice.xml. The useful reference which would be in line with the subject
  of relational databases is "Building Oracle XML Applications" by Steve Muench from O'Reilly. Actually, chapter 7 on XSLT is available on web, see http://www.oreilly.com/catalog/orxmlapp/chapter/ch07.html#9820. I also would recommend "XSLT Quickly" by Bob DuCharme from Manning, see section 3.6 "Copying Elements to Result Tree". To extract Customer element from Invoice you may consider something like:
  <xsl:template match="Customer">
  <xsl:copy-of select=".">
  </xsl:template>
  Regards,
  Igor Dayen