![](https://blogs.ontoorsolutions.com/wp-content/uploads/2023/01/image-321-1024x485.png)
SELECT XMLELEMENT ("ROW",
XMLFOREST (empno,
ename,
hiredate,
sal,
deptno,
mgr,
comm))
FROM emp;
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2023/01/image-322-1024x264.png)