Can one use dynamic SQL within PL/SQL? OR Can you use a DDL in a procedure ? How ? Thank you in advance.
asked Jan 20, 2010 at 02:04 PM in Default
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:
answered Jan 21, 2010 at 01:39 AM