Native Dynamic SQL and Dynamic PL/SQL
Lakshman Bulusu · Apress eBooks · 2003
Oracle supports two types of SQL: static SQL and dynamic SQL. In static SQL , the SQL statement is fully known at compile time and syntax and semantic references are resolved at compile time. In dynamic SQL , the SQL statements are constructed as strings and executed dynamically at runtime. This is true for PL/SQL also. Native dynamic SQL is an implementation of dynamic SQL and dynamic PL/SQL that’s integrated into PL/SQL. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.