Creating flexible and reusable procedures
A reusable procedure can be called from multiple procedures. A flexible procedure can be reused and it accepts different inputs and produces output based on that input. Dynamic Structured Query Language (SQL) falls within this definition. But what about the procedures that take advantage of dynamic SQL? How can they be written so that they easily adapt to the ever-changing needs of the business?
This chapter provides the answers to those questions and more. It includes the following topics: