DYNAMIC SQL vs EMBEDDED SQL

  SQL (Structured Query Language) – It   is used to retrieve and edit data or information stored in a database. In 1986, the American National Standards Institute (ANSI) and the International Organization for Standardization (ISO) both recognised SQL as a standard.   DYNAMIC SQL? SQL statements that are generated or executed dynamically are known as run-time SQL statements. Users can run their queries in some apps by using dynamic SQL. At runtime, these statements are compiled. When the data recorded in our database is not uniform, these kinds of SQL queries are employed. Compared to embed SQL, it is more adaptable and can be employed in some dynamic applications. WHEN TO USE DYNAMIC SQL? When static SQL cannot accomplish the task you want it to or when you are unsure of the precise SQL lines that a PL/SQL process must run, you should utilize dynamic SQL. The following sections outline common scenarios in which dynamic SQL should be used and typical issues that dynamic SQL may help wit