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_11

11. Stop Coding and Start Writing

Jon Heller¹ 

(1)

Clive, IA, USA

 

Part I explained the importance of SQL and built a solid foundation for SQL development. Part II discussed sets and advanced features needed to build powerful SQL statements. We now have the motivation, efficient processes, and advanced knowledge, but that is not enough. Part III discusses the styles and patterns needed to write elegant SQL.

Why should we care about writing elegant SQL? There are many times when our code quality doesn’t matter. Despite what we were promised about the re-usability of software, in practice most of our code is only used once and then forgotten. For most development, ...