Last modified on 3 September 2014, at 11:15

Oracle Programming/Using Conversion Functions and Conditional Expressions

Describing various types of conversion functions that are available in SQLEdit

Implicit data type conversion

Implicit conversion occurs when Oracle attempts to convert the values, that do not match the defined parameters of functions, into the required data types.

Explicit data type conversion Explicit conversion occurs when a function like TO_CHAR is invoked to change the data type of a value.

Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functionsEdit

  • Nest multiple functions
  • Apply the NVL, NULLIF, and COALESCE functions to data

Applying conditional expressions in a SELECT statementEdit

  • Use conditional IF THEN ELSE logic in a SELECT statement