ORACLE XML From SELECT statement
Posted on 2011-03-08
I have a table; ErrTbl with 4 columns: Process, Num, Desc , StartTime.
What I like to do, is send out an email and have the table results in a nice format. In sql server, I'm able to pull the results with the following query:
td =[Process], '',
td =[Num], '',
td =[Desc], '',
td =[StartTime], '',
td =[StartTime], ''
FOR XML PATH('tr'), TYPE
I would like to get similar results using Oracle 10g. I've played around with DBMS_XMLQuery, but I'm not getting the results that I'm looking for.
Any suggestions are greatly appreciated.