Advanced Use of Oracle DECODE CASE PIVOT UNPIVOT – Free Tutorial
Duration: 17 Minutes
Introduction to the Oracle PIVOT clause (and UNPIVOT)
The original SQL language focused on providing standard selection, projection, and sorting of data. Enhancements over the years allow SQL to deliver much more robust analysis of data. This webinar investigates how DECODE, CASE, PIVOT, and UNPIVOT provide these capabilities. A brief introduction to the Oracle CASE expression is also provided.
After a brief review, we will show how these features allow you to do range comparisons, create horizontal and vertical histograms, and flip tables on the side by converting rows into columns and columns into rows. These features are particularly useful to identify trends in data.
Audience: Oracle and APEX developers who want to improve their SQL skills. A basic foundation in SQL is required.
This is a multi-part tutorial. Part 1 is available now.
If you are a student of an accredited academic institution call us for a 25% discount.