Next in thread → Next in month →

Re: [xml-dev] Oracle table to XML file

From
Steve Muench <>
To
Date
2002-10-25T23:56:30Z
ID
<00cd01c27c82$23a8e860$cb672382@smuenchlap>
Thread
Re: [xml-dev] 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
Next in thread → Next in month →