Dynamic SQL and Embedded SQL

SQL is a Structured Query Language, which is a computer language for storing, manipulating and retrieving data stored in a relational database. SQL is the standard language for Relational Database Systems. SQL queries can be of two types i.e. Dynamic SQL and Embedded or Static SQL.   What is Dynamic SQL? Dynamic SQL is a programming technique that enables you to create and execute SQL statements dynamically at runtime. The users can execute their own queries in some applications. These statements are compiled at the run-time. These kinds of SQL statements are used where there is a non-uniformity in the data stored in the database. It is more flexible as compared to Embedded SQL and can be used in some flexible applications because the full text of a SQL statement may be unknown at compilation. For example, dynamic SQL lets you create a procedure that operates on a table whose name is not known until runtime. Since the compilation is done at run-time, the system will know how to acc...