Pro Oracle SQL Development: Best Practices for Writing Advanced Queries

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

J. HellerPro Oracle SQL Developmenthttps://doi.org/10.1007/978-1-4842-8867-2_6

6. Build Sets with Inline Views and ANSI Join Syntax

Jon Heller¹  

(1)

Clive, IA, USA

 

We’re almost ready to dive into advanced SQL features. In Part I we built a solid foundation for SQL programming, but before we start using advanced features, we need to discuss how to construct our SQL statements.

The best way to write SQL statements is to create nested sets using inline views and the ANSI join syntax. First, we need to discuss common SQL problems – spaghetti code caused by the old join syntax and too much context. Sets, chunking, and functional programming can help us create simpler ...