Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement