Dynamic Structured Query Language (Dynamic SQL)
Definition - What does Dynamic Structured Query Language (Dynamic SQL) mean?
Dynamic SQL statements are not embedded in the source program but stored as strings of characters that are manipulated during a program's runtime. These SQL statements are either entered by a programmer or automatically generated by the program. This is the major difference between dynamic SQL and static SQL statements. Dynamic SQL statements also may change from one execution to the next without manual intervention.
Dynamic SQL facilitates automatic generation and manipulation of program modules for efficient automated repeating task preparation and performance.
Techopedia explains Dynamic Structured Query Language (Dynamic SQL)
Dynamic SQL increases processing and efficiency by running simultaneous queries and distributing results from a single interface query on multiple databases.
Early Oracle database versions with PL/SQL dynamic SQL required that programmers to use a complicated Oracle DBMS_SQL package library. Later, a simpler "Native Dynamic SQL" was introduced.