XMLCAST

Syntax

Description of the illustration xmlcast.eps

(datatype::=)

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 XMLCAST when it is a character value