Chapter 17. Exploring Data Warehousing Features
This chapter revisits some of the concepts and functionality discussed in previous chapters, including the DECODE function, the CASE expression, and aggregate functions. You will see how to use the PIVOT and UNPIVOT clauses to effortlessly produce cross-tab queries. This will help expand on your existing knowledge and enable you to solve more complex queries.
Analytical functions allow you to explore information in ways never imagined before. You can use analytical functions to determine rankings, perform complex aggregate calculations, and reveal ...
Get Oracle SQL By Example 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.
