What are Conversion Functions?
The functions used to convert a value from one datatype to another are being termed as conversion functions. Function Name Purpose To_char(n,(fmt)) Converts a value of number datatype to a value of character datatype. To_number(n) converts a character value into a number. rowidtochar(n) converts rowid values to character datatype. the result of this conversion is always 18 character long.