• Info
• Initial State
• View Source
• Run

XML from Data Base Examples

XS-E-0 Overview

XMLELEMENT() function.

XMLELEMENT() function. Overview

XMLELEMENT takes an element name for identifier, an optional collection of attributes for the element, and arguments that make up the element's content. It returns an XML element. The second parameter may be omitted and at that time the rest parameters may be present. If one of the arguments is a call of the xpath_eval returning an attribute value, then this value would be added to element's content (not to element's attributes).

XMLATTRIBUTES() function. Overview

This function creates a vector that may be used only as argument of XMLELEMENT function. The vector has an even number of elements, each odd element is a name of an attribute, an even element is its value. If the attribute value is NULL, then no attribute and no value is created. If none of the attribute is created, then the function returns null. If a parameter of the function is a column name, then you can omit the 'AS clause', and Virtuoso uses the partially escaped form of the column name as the attribute name.

sx_e_? Demos

Countinue with the next sx_e_? demos to see examples of functoins usage