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