Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

Explicit Conversion

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