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

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 ...

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