Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

A. Nuijten, P. BarelModern Oracle Database Programminghttps://doi.org/10.1007/978-1-4842-9166-5_2

2. Analytic Functions and (un)Pivoting

Alex Nuijten¹   and Patrick Barel²

(1)

Oosterhout, Noord-Brabant, The Netherlands

(2)

Almere, Flevoland, The Netherlands

 

It happens all too often that end users of a database application ask for exports in Excel so that they can manipulate the data to get the information they need to make business decisions. Often the required information can be retrieved by using SQL in a format that the end users are looking for, thus eliminating the manual manipulation of data after export. The more extensive your knowledge of SQL, the more ...