Chapter 04-Using Conversion Functions and Conditional Expressions(00)

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

转载于:https://www.cnblogs.com/arcer/archive/2013/04/12/3016670.html