XMLAGG (
XML_value_expr
[ ORDER BY order_by_spec [,...] ]
[ RETURNING { CONTENT | SEQUENCE } ]
)
Syntax Elements
- order_by_spec
sort_key [ ASC | DESC ] [ NULLS { FIRST | LAST } ]
- XML_value_expr
- An instance of the XML type.
- ORDER BY
- The resulting values are ordered as follows:
- ASC - in ascending order
- DESC - in descending order
- NULLS FIRST - Nulls are ordered first
- NULLS LAST - Nulls are ordered last
- RETURNING CONTENT
- The return value is an XQuery document node.
- RETURNING SEQUENCE
- The return value is a sequence. This is the default.
- sort_key