Can one use dynamic SQL within PL/SQL? OR Can you use a DDL in a procedure ? How ? Thank you in advance.
asked
Can one use dynamic SQL within PL/SQL?
You can use dynamic SQL. The EXECUTE command is helpful for this. I supplied an example of that:
You can't use DDL in a regular stored procedure statement.
However, you can execute DDL with the EXECUTE statement. In fact, Oracle considers "TRUNCATE," which is in my example, to be DDL.
Here's a bit of explanation:
