Explicit Conversion : Data Type Conversion « PL SQL Data Types « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Data Types
  3. Data Type 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


21.9.Data Type Conversion
21.9.1.Datatype Conversions: Implicit Conversion
21.9.2.Explicit Conversion