Oracle PL[s]SQL by Example

In the previous 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. They are new PL/SQL features and are not supported by PL/SQL in versions prior to Oracle 9i. You will also learn how to use NULLIF and COALESCE functions that are considered an extension of CASE.