Toad World® Forums

How to XML output from sql query

Hi all,

I was new to toad. I have sql query to show the xml output in toad i was getting output of (ORAXML). I was using oracle database.Can any

Sample sql query:

SELECT XMLELEMENT(“name”, e.EMP_NAME) AS employee
FROM emp e
WHERE EMP_ID = 2;