XMLDOCUMENT

The XMLDOCUMENT function returns an XML value.

XMLDOCUMENT(,XML-expression)
XML-expression
An expression that returns an XML value.

The result of the function is XML. If the result of XML-expression can be null, the result can be null; if every XML-expression is null, the result is the null value.

Example

  • Insert a constructed document into an XML column.
    INSERT INTO T1 VALUES(123, 
                (SELECT XMLDOCUMENT(
                     XMLELEMENT(NAME "Emp", 
                                       E.FIRSTNME || ' ' || E.LASTNAME, 
                                XMLCOMMENT('This is just a simple example')
                              ))
                    FROM EMPLOYEE E
                    WHERE E.EMPNO = '000120'))