In this chapter, you will learn
Dynamic SQL is a method of SQL programming that allows you to write robust and flexible code. So far, only static SQL has been used in our SQL procedures, and the distinction between dynamic SQL and static SQL has not been made. At this stage, you may not even know that SQL can be classified as static or dynamic, but don't worrysuch details will be covered first. Then, this chapter will discuss the different ways of using dynamic SQL in SQL procedures. Then we will highlight restrictions and advanced techniques of using dynamic SQL.