Solved

retrive from database table and put in xml

Posted on 2007-04-09
2
211 Views
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 ?
0
Comment
Question by:anup001
2 Comments
 
LVL 9

Accepted Solution

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

http://search.cpan.org/~timb/DBI-1.54/DBI.pm

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

Assisted Solution

by:Vivek Thangaswamy
Vivek Thangaswamy earned 250 total points
ID: 18881049
Hi

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
http://rustemsoft.com/oraxml.htm
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Installing Git and chefdk via bat script 8 72
issue with beginner powershell script. 5 60
Perl Untar File 1 41
Macro to import XML in Access 2013 2 35
Email validation in proper way is  very important validation required in any web pages. This code is self explainable except that Regular Expression which I used for pattern matching. I originally published as a thread on my website : http://www…
A year or so back I was asked to have a play with MongoDB; within half an hour I had downloaded (http://www.mongodb.org/downloads),  installed and started the daemon, and had a console window open. After an hour or two of playing at the command …
Learn the basics of if, else, and elif statements in Python 2.7. Use "if" statements to test a specified condition.: The structure of an if statement is as follows: (CODE) Use "else" statements to allow the execution of an alternative, if the …
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

776 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