O'Reilly logo

Oracle by Elena Silvestrova Rakhimov, Benjamin Rosenzweig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5 Conditional Control: CASE Statements

Chapter Objectives

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.

Lab 5.1 CASE Statements

Lab Objectives

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required