Re: Oracle table to XML file
| Is it possible to export a Oracle table to a xml file with the C parser? From a C program you can use the inside-the-database SQL-to-XML functionality in the DBMS_XMLQUERY package to fetch the XML representation of any query result like this: select dbms_xmlquery.getxml('select * from emp') from dual If you are using Oracle9i Release 2, you have several new options that offer higher-performance as well. __________________________________________________________________ Steve Muench - Developer, Product Mgr, Java/XML Evangelist, Author Simplify J2EE Development with the Oracle BC4J Framework http://otn.oracle.com/products/jdev/htdocs/j2ee_bc4j.html Building Oracle XML Apps, http://www.oreilly.com/catalog/orxmlapp
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format