Choose any two DBMS packages and discuss their usage pertinent in your application.

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 in your application.

The DBMS_DDL package allows running DDL statements to recompile and analyze database objects from PL/SQL code. Showcase the usage of DBMS_DDL in your application.

Oracle has two methods for hiding code: the wrap utility and the DBMS_DDL package. The wrap utility is a command-line tool that processes script files containing CREATE statements for program units. The DBMS_DDL package can wrap a single program unit that's generated dynamically. Which one would you prefer to use and why? Provide your rationale about your choice of method for hiding code.