5
Conditional Control: CASE Statements
In the previous chapter, you explored the concept of conditional control via IF and ELSIF statements. In this chapter, you will continue this exploration by examining different types of CASE statements and expressions. You will also learn how to use NULLIF and COALESCE functions, which are considered extensions of CASE.
Lab 5.1: CASE Statements
A CASE statement has two forms: CASE and searched CASE. A CASE statement allows you to specify a selector that determines which group of actions to take. A searched CASE ...
Get Oracle PL/SQL by Example, 6th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
