Scalar. Creates a new XML data element, with attributes and XML expressions within it.
xmlelement ( name, [xmlattributes (string AS name, ..., string AS name),] [ XML value, ..., XML value] )
| string | Attribute name/value pairs. For example: 'attrValue' AS attrName results in attrName = "attrValue" attribute created in the resulting XML element. |
| name | The name of the new element. Must adhere to naming conventions. |
| XML value | An XML value representing a child element. |
Creates a new XML data element, with attributes and XML expressions within it. The function takes . The function returns an XML value.
xmlelement (top, xmlattributes('data' as attr1), xmlparse('<t/>')) returns a new XML element called top, with a 'data' attribute and <t/> child element.