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 tr... View More