DBMS_SQL, a comprehensive supplied package API to dynamic SQL operations. Generally, EXECUTE IMMEDIATE will handle almost all your dynamic SQL requirements. Consider using DBMS_SQL primarily for the ...

The "in tab" procedure displays what's in a table, using DBMS_SQL and method 4 dynamic SQL. That is, I do not know at the time I compile my code how many columns I will displaying. Most dynamic SQL ...

That's three times as fast as the second example. However, the dynamic SQL is still at a disadvantage. The execute immediate still does its parse, ... Even in Oracle 10g, ...