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> |
