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_22

SQL Style Guide Cheat Sheet

Jon Heller¹  

(1)

Clive, IA, USA

 

Follow these style tips to write clear, powerful SQL statements. This simple list summarizes the programming style recommendations made throughout this book. There are exceptions to every rule, but we should still know what the rules are and why the rules exist:

1. 1.

   Use inline views: Build large SQL statements out of small, independent pieces with simple relational interfaces.

    
2. 2.

   Use ANSI join syntax: Build SQL statements in an orderly fashion by adding and joining one table at a time.

    
3. 3.

   Adhere to the relational model: Use ...