Generate XML using Oracle XML schema I have some XML schema definitions that have been registered using DBMS_XMLSCHEMA.  I have created tables using the XMLTypes generated.  I can create XML using XMLQuery and if I understand correctly, the query results can be inserted into the table if the definition is correct.  

Ultimately the XML needs to be written to a file, but the part I am unsure about is if writing XMLQueries from scratch is the best way to generate the XML.  Is there any way to have the XML schema generate an XML stub for a guide or generate template XMLQuery?  The data is currently all in regular Oracle tables, but arranged quite differently, so any information on easing the export to XML based on a specific set of registered schema would be useful.
It is fairly direct to push an already existing select to XML: http://docs.oracle.com/cd/B19306_01/appdev.102/b14259/xdb13gen.htm#i1028612

Creating XML is part of the basic SQL specifications and is available on most servers. You can check out SQL server's version of it here: http://blog.sqlauthority.com/2009/02/12/sql-server-simple-example-of-creating-xml-file-using-t-sql/