The CAST() function takes an expression of any type and produces a result value of a specified type, similar to CONVERT() . See the description of CONVERT() ...
docs.oracle.com