For static SQL, the statement text is available in the system catalog, and the access path information is available in the associated plan tables after binding with the EXPLAIN (YES). There is no PLAN ...

Developers often dismiss dynamic SQL used in PL/SQL programs for two reasons.

Scott Stephens creates a package that allows you to clone most database objects with dynamic SQL.

Using MS SQL Server, is there a way to query all of the tables in a database for a specific column name?Thanks,Pete ...