I have no XML experience. Can someone tell me how to perform the following:
1. Generate XML document: I am running a few queries on database A, and spooling the output to a spool file. How can I convert this into an XML document?
2. Load to another database: Now once I have the XML document, I would like to load the data into database B. I'll use this to generate some reports.

I would really appreciate if you could layout detailed procedure for me. Thanks in advance.