Chapter 6. Conditional Control: CASE Statements


Chapter Objectives

In this Chapter, you will learn about:

CASE Statements

CASE Expressions

NULLIF and COALESCE Functions


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.



Oracle PL[s]SQL by Example
Oracle PL[s]SQL by Example
ISBN: 3642256902
EAN: N/A
Year: 2003
Pages: 289

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net