Run the statement in the right.

The XMLSERIALIZE function is a more generic way of returning data from an XML function, rather than using the XML2CLOB function. The XMLSERIALIZE function will return either a CHAR, VARCHAR, or CLOB string depending on the arguments supplied.

The XMLSERIALIZE function can also return a CHARACTER string, or a CLOB. Note that the function must have a length modifier as the datatype in order to work correctly. If no value is specified for CHAR, a default length of 1 is assumed, and for a CLOB, the default length is 1M. These may not be appropriate for the application that you are running.

Try replacing the return argument of this statement to see how the output of a CHAR, VARCHAR, or CLOB changes.

You should see a result set in the lower right panel.