Dynamic SQL allows supplying identifiers, such as table names and column names, at runtime and enables you to include DDL statements in PL/SQL code. It can be implemented with the DBMS_SQL package or by using native dynamic SQL. Demonstrate an example of dynamic SQL by writing a package and a procedure

The DBMS_DDL package allows running DDL statements to recompile and analyze database objects from PL/SQL code. Showcase the usage of DBMS_DDL by writing a sample code.