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_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 dumb columns and dumb tables to create smart schemas. Never store lists ...