• Info
• Initial State
• View Source
• Run

XML from Data Base Examples

SX-E-2 Making an XML element with a text content

XML element with a text content

Example 2

This example shows a use of the XMLELEMENT() for creating the xml element 'EmployeeName' (for each employee) with the text content that is value of the 'LastName' column from the "Demo"."demo"."Employees" table.

select XMLELEMENT ("EmployeeName", "LastName") 
from "Demo"."demo"."Employees";