CODEWITHSUNDEEP
xmloracle-databaseoracle-sqldeveloper
rafeyrazvi
rafeyrazvi

Reputation: 11

How to get an XML file for an sql query result

I have to build a report using BI publisher for which i need xml file for a query result am using SQL developer for executing my queries.

Upvotes: 1

Views: 2275

Answers (2)

Nishant Sharma
Nishant Sharma

Reputation: 360

Oracle provides a lot of syntax for writing out XML formatted content from database columns.

You might want to explore some of that.

It will generate one xml document per row of your query.

If that is what you want.

Upvotes: 1

paulsm4
paulsm4

Reputation: 121849

Google "oracle bi publisher xml output" =>

http://cali97.blogspot.com/2008/01/bi-publisher-xml-publisher-can-produce.html

'Hope that helps...

Upvotes: 0

Related Questions