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_3

3. Joins

Alex Nuijten¹   and Patrick Barel²

(1)

Oosterhout, Noord-Brabant, The Netherlands

(2)

Almere, Flevoland, The Netherlands

 

Discussing join syntax with other database developers almost always leads to discussing the preferred style of joining data sources. Some are fanatic supporters of ANSI-style joins, while others prefer to stick to the traditional way. Our preferred method is the former—ANSI style.

This chapter discusses the advantages of using ANSI-style joins and describes the most common joins: outer, inner, and full. It also covers some lesser-known ...