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_9

9. Subquery Factoring, the WITH Clause, Explained

Alex Nuijten¹   and Patrick Barel²

(1)

Oosterhout, Noord-Brabant, The Netherlands

(2)

Almere, Flevoland, The Netherlands

 

Subquery factoring is also known as a common table expression (CTE). Commonly referred to as the with clause. A CTE is a named temporary result set that exists within the scope of a single statement, and that can be referred to later within that statement, possibly multiple times.

You can specify a subquery in the from clause of a query, which is called an inline view; but if you want to join the ...