CHAPTER9Shooting at a Moving Target
Dynamic SQL has been the topic of dozens of whitepapers and presentations over the years. Most of those papers and presentations have focused on familiarizing rank-and-file developers with the concept of building code on the fly. Deep discussion of the impact of Dynamic SQL on the development process is hard to find. Full-scale case studies of the production usage of Dynamic SQL have also been lacking. As a result, there is more fear and mistrust of the technology than there is meaningful understanding of it. The feedback from the Oracle Database user community causes us to reach the following conclusions:
Get Oracle PL/SQL Performance Tuning Tips & Techniques 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.
