Pro Oracle SQL Development: Best Practices for Writing Advanced Queries

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

J. HellerPro Oracle SQL Development https://doi.org/10.1007/978-1-4842-8867-2_14

14. Use SQL More Often with Basic Dynamic SQL

Jon Heller¹  

(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 ...