# How to XML output from sql query

**URL:** <https://forums.toadworld.com/t/how-to-xml-output-from-sql-query/38352>\
**Category:** Toad for SQL Server\
**Created:** [September 12, 2016, 8:13am UTC](https://forums.toadworld.com/t/how-to-xml-output-from-sql-query/38352 "2016-09-12T08:13:18Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![gopalakrishna](https://avatars.discourse-cdn.com/v4/letter/g/4bbf92/32.png) [@gopalakrishna](https://forums.toadworld.com/u/gopalakrishna)\
**Post date:** [September 12, 2016, 8:13am UTC](https://forums.toadworld.com/t/how-to-xml-output-from-sql-query/38352/1 "2016-09-12T08:13:18Z")

</div>

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;
