How to use Dynamic SQL in Form?

The reason why you would want do to do this is because, like in database procedures, you can't use DDL such as DROP TABLE 'table_name' directly in PL/SQL with Forms. The way to do it is with the buit-in EXEC_SQL package. The same thing can also be accomplished with the FORMS_DDL built-in but that only applies to the current database connection, with the EXEC_SQL package it’s possible to have database connections to multiple databases and also execute non-oracle database procedures.