CHAPTER 16DECODE and CASE: if, then, and else in SQL

The DECODE function is without doubt one of the most powerful in Oracle's SQL. It is one of several extensions Oracle added to the standard SQL language. This chapter will explore a number of ways that DECODE can be used, including the generation of "crosstab" reports. You can also use the CASE function and the COALESCE function to execute complex logical tests within your SQL statements.

DECODE and CASE are often used to pivot data—that is, to turn rows of data into columns of a report. In this chapter you will see how to use DECODE, CASE, and the PIVOT operator (introduced in Oracle 11g) to generate crosstab reports.

if, then, else

In programming and logic, a common construction of a problem ...

Get Oracle Database 11g The Complete Reference now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.