XMLCAST
Syntax
Purpose
XMLCast casts value_expression to the scalar SQL data type specified by datatype. The value_expression argument is a SQL expression that is evaluated.
datatype
The datatype argument can be of data type NUMBER, VARCHAR2, VARCHAR, CHAR, CLOB, BLOB, REF XMLTYPE, and any of the datetime data types.
BLOB, or CLOB with options reference or value. The default is reference.
See Also:
-
Oracle XML DB Developer's Guide for more information on uses for this function and examples
-
Appendix C in Oracle Database Globalization Support Guide for the collation derivation rules, which define the collation assigned to the return value of
XMLCASTwhen it is a character value