Oracle Programming/Using Conversion Functions and Conditional Expressions
From Wikibooks, open books for an open world
[edit] Describing various types of conversion functions that are available in SQL
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.
[edit] Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
- Nest multiple functions
- Apply the NVL, NULLIF, and COALESCE functions to data
[edit] Applying conditional expressions in a SELECT statement
- Use conditional IF THEN ELSE logic in a SELECT statement
