OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help



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

[ Lists Home | Date Index | Thread 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


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS