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