Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
I have a table say SCOTT.DEPT and I want to convert it into an XML document. Is there anyway to accomplish this task?
The easiest way to do this is:
select dbms_xmlgen.getxml( 'select * from dept') as xml
There are other way more complicated ways of achieving similar results, but the answer would be significantly longer!
Required, but never shown