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: PLS-00302: component 'GETBLOBVAL' must be declared
Next Topic: Jdeveloper speed Performance
Goto Forum:
  


Current Time: Tue Apr 16 17:51:42 CDT 2024