PPT Slide

They are designed to convert columns of one

datatype to another type. These functions do not

actually modify the data itself; they just return

the converted value.

Several different conversion functions are available

in the Oracle database, as listed below:

to_char(x)

to_number(x)

to_date(x[,y])

to_multi_byte(x)

to_single_byte(x)

schartorowid(x)

rowidtochar(x)

hextoraw(x)

rawtohex(x)

convert(x[,y[,z]])

translate(x,y,z)