XMLCAST

Syntax

Description of the illustration xmlcast.gif

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. The datatype argument can be of data type NUMBER, VARCHAR2, CHAR, CLOB, BLOB, REF XMLTYPE, and any of the datetime data types.

See Also:

Oracle XML DB Developer's Guide for more information on uses for this function and examples