Attributes | Values |
---|
type
| |
Title
| - Making an XML element with attribute, a text content and a sublement
|
content
| -
Example 4
This example shows a use of the XMLELEMENT() for creating the xml element 'Employee' with the
'EmployeeID' attribute, text content that is concatenations of the value of the 'FirstName' column,
of the blank character and of the value of the 'LastName', and the 'Title' subelement having
'title' attribute.
select XMLELEMENT ('Employee', XMLATTRIBUTES ("EmployeeID"), "FirstName"||' '||"LastName",
XMLELEMENT("Title", XMLATTRIBUTES ( "Title" as "title")))
from "Demo"."demo"."Employees";
|
has container
| |
description
| - XML element with attribute, a text content and a sublement
|
dcterms:created_at
| - Fri, 27 Dec 2019 14:12:54 GMT
|
content:encoded
| -
Example 4
This example shows a use of the XMLELEMENT() for creating the xml element 'Employee' with the
'EmployeeID' attribute, text content that is concatenations of the value of the 'FirstName' column,
of the blank character and of the value of the 'LastName', and the 'Title' subelement having
'title' attribute.
select XMLELEMENT ('Employee', XMLATTRIBUTES ("EmployeeID"), "FirstName"||' '||"LastName",
XMLELEMENT("Title", XMLATTRIBUTES ( "Title" as "title")))
from "Demo"."demo"."Employees";
|
is container of
of | |