XML output using oracle sql
<p>Please guide me how to get below output using oracle sql query and output should be in one row and one column(single row column). </p>

<pre><code>&lt;Row&gt;&lt;Cell&gt;&lt;Data ss:Type="String"&gt;SMITH&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell&gt;&lt;Data ss:Type="String"&gt;800&lt;/Data&gt;&lt;/Cell&gt;&lt;/Row&gt; &lt;Row&gt;&lt;Cell&gt;&lt;Data ss:Type="String"&gt;ALLEN&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell&gt;&lt;Data ss:Type="String"&gt;1600&lt;/Data&gt;&lt;/Cell&gt;&lt;/Row&gt;
</code></pre>

<hr>

<p>i tried using sql statement but i'm getting multiple rows.</p>

<pre><code>select 
'&lt;Row&gt;'||XMLELEMENT("Cell",XMLELEMENT("Data",xmlattributes('String' as  "ss:Type"),ename) )||
  XMLELEMENT("Cell",XMLELEMENT("Data",xmlattributes('String' as  "ss:Type"),sal)) ||'&lt;/Row&gt;' as "Result" from emp;
</code></pre>

<p>Thanks in advance</p>