I have to create an xml file using the data from multiple table. The problem That i am facing is the data is huge it is in millions so I was wondering that is there any efective way of creating such an xml file.
It would be great if you can suggest some approach to achieve my requirement.
SQL/XML publishing functions (XMLElement, XMLAttributes, XMLAgg etc.) :
Use the search feature to find some existing examples in this forum.