What is embedded and dynamic SQL?
SQL is a type of domain-specific language that is used to help manage databases. There are two main types of SQL, Embedded SQL and Dynamic SQL. Each has its own properties and attributes.
Embedded SQL – Embedded SQL, also known as Static SQL are SQL statements that do not change at runtime. Hence, these statements can be hard-coded into the application.
Dynamic SQL – Dynamic SQL are statements that are constructed at runtime. Therefore, the application may allow users to enter their own queries. Dynamic SQL can also be used to create more general purpose and flexible applications as the full text of a SQL statement may be unknown at compilation.