• Info
• Initial State
• View Source
• Run

XML from Data Base Examples

SX-E-6 Making an XML element with nested XMLFOREST() function

XML element with XMLFOREST() function call as parameter

Example 6

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

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