SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How To Write XML File from a select Query.

890271Jul 4 2012 — edited Jul 4 2012

Hi All,

i need to write a xml file from a select query, Kindly Share Ur Ideas.

Database : Oracle Database 10g 10.1.0.2.0.

Ex. Select Menu_id,Menu_type from Menu_master where menu_type='ADMIN';

i can get xml format data using

select xmlelement(
"MENU",
xmlforest(
menu_id,
menu_name
)
) xml
from menu_master;

but, How to create a xml file for this data.

Thanks in Advance.

Edited by: 887268 on Jul 4, 2012 1:31 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 1 2012

Added on Jul 4 2012

#file, #from, #query, #select, #to, #xml

2 comments

526 views