Home » Developer & Programmer » JDeveloper, Java & XML » Sqlplus output as xml
Sqlplus output as xml [message #225280] Mon, 19 March 2007 08:55 Go to next message
Colm
Messages: 22
Registered: June 2005
Junior Member
Hello all,


I just want to know if it's possible to have a standard sqlplus .sql report output in xml format so that it can be opened in Microsoft Excel and retain all it's correct headings and columns without any further formatting to be done. I have read that the Oracle Reports software in 10g can do this but I want to know about sqlplus.

What Oracle database and associated downloads are required to allow this (if possible) and where can I find more information on this ?

Thanks,

C.
Re: Sqlplus output as xml [message #225287 is a reply to message #225280] Mon, 19 March 2007 09:32 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Search before posting.
http://www.orafaq.com/forum/m/213147/42800/?srch=xmlgen#msg_213153
Previous Topic: how to use j2ee as container to run java programs
Next Topic: Loading XML file into Multipul table using Java
Goto Forum:
  


Current Time: Sat Apr 20 06:18:02 CDT 2024