XMLCOMMENT

SQLRF52006Syntax

SQLRF52007Purpose

XMLComment generates an XML comment using an evaluated result of value_expr. The value_expr must resolve to a string. It cannot contain two consecutive dashes (hyphens). The value returned by the function takes the following form:

<!--string-->

If value_expr resolves to null, then the function returns null.

SQLRF52008Examples

The following example uses the DUAL table to illustrate the XMLComment syntax:

SELECT XMLCOMMENT('OrderAnalysisComp imported, reconfigured, disassembled')
   AS "XMLCOMMENT" FROM DUAL;
 
XMLCOMMENT
--------------------------------------------------------------------------------
<!--OrderAnalysisComp imported, reconfigured, disassembled-->