retrive from database table and put in xml

Posted on 2007-04-09
Medium Priority
Last Modified: 2010-04-16
I have a few records in a table in oracle database. I want to retrived a set of numbers based on a query and then put each number in an xml file.

So bascially want to pick up data from teh database and ut it in the xml file. How can I do it ?
Question by:anup001

Accepted Solution

Suhas . earned 1000 total points
ID: 18880346
for retriving from database, use DBI module,


open an xml file in write mode, and dump the extracted data to that file.
LVL 11

Assisted Solution

by:Vivek Thangaswamy
Vivek Thangaswamy earned 1000 total points
ID: 18881049

Ref this link
http://www.psoug.org/reference/xmlquery.html  this Oracle query will returns the data as XML

Using an Oracle View to store query results as an XML output

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Active Directory replication delay is the cause to many problems.  Here is a super easy script to force Active Directory replication to all sites with by using an elevated PowerShell command prompt, and a tool to verify your changes.
Create a Windows 10 custom Image with custom task bar and custom start menu using XML for deployment.
Learn the basics of while and for loops in Python.  while loops are used for testing while, or until, a condition is met: The structure of a while loop is as follows:     while <condition>:         do something         repeate: The break statement m…
The viewer will learn how to count occurrences of each item in an array.

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question