Using Conversion Functions and Conditional Expressions
After completing this lesson,you should be able to do the following:
- Describe various types of conversion functions that are available in SQL
- Use the TO_CHAR,TO_NUMBER,and TO_DATE conversion functions.
- Apply conditional expressions in a SELECT statement.
Lesson Agenda
- Implicit and explict data type conversion
- TO_CHAR,
- TO_DATE,
- TO_NUMBER
- Netsting functions
- General functions
- -NVL
- -NVL2
- -NULLIF
- -COALESCE
- Condtitional expressions
- -CASE
- -DECODE