Listing B offers a better comparison with dynamic SQL. This code runs about twice as slow as the first block. That's three times as fast as the second example. However, the dynamic SQL is still at ...

For example, using dynamic SQL puts more responsibility on programmers to avoid security exposures, such as SQL injection attacks. But the bottom line is that dynamic SQL is a viable option for ...

Scott Stephens creates a package that allows you to clone most database objects with dynamic SQL.