troubleshooting Question

ORACLE XML From SELECT statement

Avatar of DBL9SSG
DBL9SSGFlag for United States of America asked on
Oracle Database
23 Comments2 Solutions987 ViewsLast Modified:
Hello Experts,

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:

SELECT
td =[Process], '',
td =[Num],   '',
td =[Desc],   '',
td =[StartTime],   '',
td =[StartTime],   ''      
FROM ErrTbl            
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.

Thank you
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 23 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 23 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros