• Info
• Initial State
• View Source
• Run

XML from Data Base Examples

SX-E-5 Making an XML element with two nested subelements

XML element with two nested subelements

Example 5

This example shows a use of the XMLELEMENT() for creating the xml element 'FullName' with two subelements 'firstname' and 'lastname'. Both subelements have the simple text content.

select
      XMLELEMENT ('FullName',
                        XMLELEMENT ('firstname', "FirstName"),
                        XMLELEMENT ('lastname', "LastName"))
from "Demo"."demo"."Employees";