Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

XMLCONCAT function [String]

Produces a forest of XML elements.

XMLCONCAT( xml-value [, ... ])

xml-value    The XML values to be concatenated.

Generates a forest of XML elements. In an unparsed XML document, a forest refers to the multiple root nodes within the document. NULL values are omitted from the result. If all the values are NULL, then NULL is returned. The XMLCONCAT function does not check whether the argument has a prolog. If you require a well-formed XML document, you must ensure that your query is written so that a single root element is generated.

Element content is always escaped unless the data type is XML. Data in BINARY, LONG BINARY, IMAGE, and VARBINARY columns is automatically returned in base64-encoded format when you execute a query that contains a XMLCONCAT function.

• Using the XMLCONCAT function
• XMLFOREST function [String]
• String functions

• Part of the SQL/XML draft standard.

The following query generates <CustomerID>, <cust_fname>, and <cust_lname> elements for each customer.

SELECT XMLCONCAT( XMLELEMENT ( NAME CustomerID, ID ),
                  XMLELEMENT( NAME cust_fname, GivenName ),
                  XMLELEMENT( NAME cust_lname, Surname )
                 ) AS "Customer Information"
FROM Customers
WHERE ID < 120;