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_20

20. Use SQL More Often with Advanced Dynamic SQL

Jon Heller¹  

(1)

Clive, IA, USA

 

SQL is Oracle’s greatest strength. Dynamic SQL is important because it gives us more opportunities to use SQL. Chapter 14 introduced the basic features: using dynamic SQL for DDL, unknown objects, and simplifying privileges; EXECUTE IMMEDIATE and bind variable syntax; simplifying dynamic code with multiline strings, alternative quoting syntax, and templating; and the benefit of generating code instead of creating generic code.

Now it’s time to discuss advanced dynamic SQL. These features let us push ...