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_12

12. Write Large SQL Statements

Jon Heller¹ 

(1)

Clive, IA, USA

 

We must write large SQL statements to take full advantage of the power of Oracle SQL. Large procedures are an anti-pattern in procedural programming languages; we need to understand why SQL is different. Large SQL statements create several risks and opportunities; we must be aware of the consequences of parsing, optimizer transformations, resource consumption, context switches, and parallelism. Finally, we need to learn how to read and debug large SQL statements.

Imperative Programming Size Limits Do Not Apply

Not all of the rules we learned from imperative programming apply to declarative ...