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_15

15. Avoid Anti-Patterns

Jon Heller¹ 

(1)

Clive, IA, USA

 

So far this book has mostly focused on what we should do. It is also helpful to discuss the things we should not do. This chapter contains a list of anti-patterns – programming concepts and styles that we should avoid.

Anti-patterns are subtle mistakes, not merely trivial compiler errors that we can immediately fix. Anti-patterns are mistakes that might save us time today but cost us more time tomorrow. We need to proactively avoid certain shortcuts so we don’t accumulate too much technical debt.

The anti-patterns in this chapter are based on my 17 years of experience with Oracle. For many of those ...