Native Dynamic SQL and Dynamic PL/SQL

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…