ORACLE, XML, XMLFOREST - SIMPLE EXAMPLE 1

WITH thinker AS(
SELECT 1 AS THINKER_ID, 'Ciceron' AS THINKER_NAME, 'Roma' AS THINKER_PLACE FROM DUAL

)
SELECT
  XMLELEMENT("THINKER",
    XMLFOREST(t.THINKER_ID AS "ID", t.THINKER_NAME AS "NAME", t.THINKER_PLACE AS "PLACE")
  ) AS XML_ROW
FROM thinker t
----------------------------------
<THINKER>
    <ID>1</ID>
    <NAME>Ciceron</NAME>
    <PLACE>Roma</PLACE>
</THINKER>