Home » Developer & Programmer » JDeveloper, Java & XML » Oracle table data to a XML format
Oracle table data to a XML format [message #199128] Fri, 20 October 2006 06:10 Go to next message
bhoite_amol83
Messages: 110
Registered: June 2005
Location: Pune
Senior Member
Hi Friends,
I am new with Oracle XML packages and all things regarding this.
I have some task that i have one view. I want to create migrate view data to a XML file.
How can i do it? or in which way of PL/SQL coding i can do it?

Only way i m aware of is XMLELEMENT.

Also met me know about the documentation regarding Oracle XML.

Any type of help will be appreciable.

Thanks in advance.

Amol.
Re: Oracle table data to a XML format [message #201247 is a reply to message #199128] Fri, 03 November 2006 04:55 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You need the XML Developers Guide, Chapter 10, Generating XML From the Database

Useful functions to look at include XMLFOREST, XMLAGG, XMLATTRIBUTES and XMLSEQUENCE
Previous Topic: Using DBMS_XMLDOM to insert into table
Next Topic: Problem in validating the XML with XSD in Oracle
Goto Forum:
  


Current Time: Wed Aug 23 10:33:39 CDT 2017

Total time taken to generate the page: 0.05184 seconds