Attributes | Values |
---|
type
| |
Title
| - Making an XML element with the entity objects as parameters
|
content
| -
Example 9
This example creates an 'FullAddress' element with
four attributes, three of them ('PostalCode', 'Address', 'City') are
produced by XMLATTRIBUTES, and the fourth attribute - 'country' is calculated by
xquery_eval
'Region' subelement, that is produced by xtree_doc
text content, that is produced by xpath_eval
'emp' subelement with text content from the column "LastName", that is created by nested
XMLELEMENT
select XMLELEMENT ('FullAddress',
XMLATTRIBUTES ( "PostalCode", "Address", "City"),
xtree_doc ('<Region>WA</Region>'),
xquery_eval('//@country', xtree_doc('<a country="USA"/>')),
xpath_eval('//@Phone', xtree_doc('<a Phone="(206) 555-9857"/>')),
XMLELEMENT('emp', "LastName"))
from "Demo"."demo"."Employees"
|
has container
| |
description
| - XML element with the entity objects as parameters
|
dcterms:created_at
| - Fri, 27 Dec 2019 14:12:54 GMT
|
content:encoded
| -
Example 9
This example creates an 'FullAddress' element with
four attributes, three of them ('PostalCode', 'Address', 'City') are
produced by XMLATTRIBUTES, and the fourth attribute - 'country' is calculated by
xquery_eval
'Region' subelement, that is produced by xtree_doc
text content, that is produced by xpath_eval
'emp' subelement with text content from the column "LastName", that is created by nested
XMLELEMENT
select XMLELEMENT ('FullAddress',
XMLATTRIBUTES ( "PostalCode", "Address", "City"),
xtree_doc ('<Region>WA</Region>'),
xquery_eval('//@country', xtree_doc('<a country="USA"/>')),
xpath_eval('//@Phone', xtree_doc('<a Phone="(206) 555-9857"/>')),
XMLELEMENT('emp', "LastName"))
from "Demo"."demo"."Employees"
|
is container of
of | |