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_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 Oracle to its limits, and let us walk the line between overly generic madness ...