Lists Home |
Date Index |
| 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
Building Oracle XML Apps, http://www.oreilly.com/catalog/orxmlapp