XMLATTRIBUTES

The XMLATTRIBUTES function constructs XML attributes from the arguments provided. The result is an XML sequence with an attribute node for each input value.

Syntax

XMLATTRIBUTES ( <XML_attribute_value> [ AS <XML attribute_name> ] [ { , <XML_attribute_value> [ AS <XML attribute_name> ] }... ] )

In the syntax, XML_attribute_value is a value expression, and XML_attribute_name is the element identifier.

Remarks

•

XMLATTRIBUTES can only be used as an argument of the XMLELEMENT function.

•

This function requires the AS keyword if aliases are used. This is in contrast to the select-list, which does not require the AS keyword for aliasing.

•

This function cannot be used to insert blank spaces or newline characters.

•

Any <value expression> that evaluates to NULL is ignored.

•

Each <value expression> must have a unique attribute name.

•

If the result of every <value expression> is NULL, the result is NULL.

Example

SELECT XMLELEMENT (name Details, XMLATTRIBUTES (product_id,name as "Name"), 

	XMLELEMENT (name orderno, OrderID), 

	XMLELEMENT (name status, Status), 

	XMLELEMENT (name price, UnitPrice)) myOutput

FROM /shared/examples/ds_orders/orderdetails

WHERE ProductID < 20