Oracle PL/SQL Best Practices

Dynamic SQL and Dynamic PL/SQL

“Dynamic” means that the SQL statement or PL/SQL block that you execute is constructed, parsed, and compiled at runtime, not at the time the code is compiled. Dynamic SQL offers a tremendous amount of flexibility—but also complexity.

With Oracle8i and above, you can use native dynamic SQL (NDS) to take care of dynamic SQL. Prior to Oracle8i, you must rely on the DBMS_SQL built-in package.