Pro Oracle SQL Development: Best Practices for Writing Advanced Queries

© Jon Heller 2019

Jon HellerPro Oracle SQL Development https://doi.org/10.1007/978-1-4842-4517-0_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. 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 queries. We will combine those three concepts and implement them with inline ...