Oracle Programming/Using Conversion Functions and Conditional Expressions

From Wikibooks, open books for an open world
Jump to: navigation, search

Describing various types of conversion functions that are available in SQL[edit]

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 functions[edit]

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

Applying conditional expressions in a SELECT statement[edit]

  • Use conditional IF THEN ELSE logic in a SELECT statement