
The XMLDOCUMENT function 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.
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'))
