Oracle has several built-in functions that are designed to convert information from one datatype to another.
Conversion functions.
FunctionPurpose
TO_DATEConverts a character string to a date
TO_NUMBERConverts a character string to a number
TO_CHARConverts either a number or a date to a character string