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.

You might also want to review our Oracle SQL tutorials and see our Oracle training page for information about formal training courses both on-line and in person.

Click here to post comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Oracle Questions.