View difference between Paste ID: NcQbfG7u and rtMv66JU
SHOW: | | - or go back to the newest paste.
1
WITH thinker AS(
2-
SELECT 1 AS THINKER_ID, 'Ciceron' AS THINKER_NAME, 'Roma' AS THINKER_PLACE FROM DUAL
2+
  SELECT 1 AS THINKER_ID, 'Ciceron' AS THINKER_NAME, 'Roma' AS THINKER_PLACE FROM DUAL)
3-
    
3+
  
4-
)
4+
5
  XMLELEMENT("thinker",
6-
  XMLELEMENT("THINKER",
6+
  XMLCONCAT(
7-
    XMLFOREST(t.THINKER_ID AS "ID", t.THINKER_NAME AS "NAME", t.THINKER_PLACE AS "PLACE")
7+
    XMLELEMENT("ID",t.THINKER_ID),
8-
  ) AS XML_ROW
8+
    XMLELEMENT("ID",t.THINKER_NAME))) AS XML_ROW
9
FROM thinker t
10-
----------------------------------
10+
-----------------------------------------
11-
<THINKER>
11+
<thinker><ID>1</ID><ID>Ciceron</ID></thinker>