Data conversion functions in oracle?

by neelima
(Hyderabad)

QUESTION:
What are the data conversion functions in Oracle?

ANSWER:
Oracle has a large number of conversion functions (for example) to convert dates to character strings and vice versa, to convert numbers to character strings and vice versa, to convert hexadecimal to raw (binary), to convert character strings to time intervals, etc.

A description of all the conversion functions, their syntax, and examples of use are available in the Oracle SQL Language Reference available from the Oracle Technology Network along with all the other documentation for Oracle databases, Oracle Fusion Middleware, applications and the recently acquired products and technologies from Sun Microsystems.