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
posted @ 2013-04-12 14:45  ArcerZhang  阅读(128)  评论(0)  编辑  收藏  举报