[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: Oracle table to XML file

• To: <wstroop@g...>
• Subject: Re: Oracle table to XML file
• From: "Steve Muench" <Steve.Muench@o...>
• Date: Fri, 25 Oct 2002 16:56:30 -0700
• Cc: "Xml-Dev" <xml-dev@l...>
• References: <3DB98350.5D142D16@g...>

| 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

• References:
  • Oracle table to XML file
    • From: "Wesley STROOP" <wstroop@g...>

• Prev by Date: Re: The Browser Wars are Dead! Long Live the Browser Wa rs!
• Next by Date: Re: [ANN] "Future of Software and Databases" NetSeminar (December 3)
• Previous by thread: Oracle table to XML file
• Next by thread: RE: Tight binding with backend systems (Was: What is XML For?)
• Index(es):
  • Date
  • Thread