© Jon Heller 2019
Jon HellerPro Oracle SQL Development https://doi.org/10.1007/978-1-4842-4517-0_14

14. Use SQL More Often with Basic Dynamic SQL

Jon Heller1 
(1)
Clive, IA, USA
 

Dynamic SQL is a powerful tool that helps us get the most out of Oracle SQL. With dynamic SQL we can build our code at run time. Writing code in code is challenging but offers many opportunities.

First we need to understand when we must use dynamic SQL, when we want to use dynamic SQL, and when we do not want to use dynamic SQL. The basic features of dynamic SQL are simple, but we have to be careful to preserve performance and security. Generating source code is tricky and we need to use specific programming styles to make dynamic code manageable. When we’re comfortable with ...

Get Pro Oracle SQL Development: Best Practices for Writing Advanced Queries now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.