• Info
• Initial State
• View Source
• Run

XML from Data Base Examples

SX-E-7 Making an XML element with nested XMLCONCAT() function

XML element with XMLCONCAT() function call as parameter

Example 7

The example shows a use of the XMLELEMENT() with the nested call of XMLCONCAT() function. The result is identical to the previous two examples.

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