In this chapter, you will learn about
• CASE statements
• CASE expressions
• NULLIF and COALESCE functions
In the preceding chapter, you explored the concept of conditional control via IF and ELSIF statements. In this chapter, you will continue by examining different types of CASE statements and expressions. You will also learn how to use NULLIF and COALESCE functions that are considered an extension of CASE.
After completing this lab, you will be able to
• Use the CASE statement
• Use the searched CASE statement
A CASE statement has two forms: CASE and searched CASE. A CASE statement allows you to specify a selector that determines which ...