August 2014
Intermediate to advanced
336 pages
7h 58m
English

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: