XMLTEXT

The XMLTEXT function returns an XML value having the input argument as its content. XMLTEXT accepts a character argument and returns the string after it has been escaped. See section Text Escaping

Syntax

XMLTEXT ( <character_value_expression> [ <XML_returning_clause> ] )

Remark

•

If the character argument evaluates to NULL, NULL is returned.

•

The character value expression can accept NULL, INTEGER, FLOAT, DECIMAL, DATE, TIMESTAMP, TIME, CLOB, BLOB, VARCHAR, and CHAR.

Example

SELECT XMLELEMENT (name company,

XMLTEXT (customers.CompanyName) ) "Company Name", XMLTEXT (customers.City) City

FROM /shared/examples/ds_orders/customers customers