Sqlplus output as xml [message #225280] |
Mon, 19 March 2007 08:55 |
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.
|
|
|
|