|
Can one use dynamic SQL within PL/SQL? OR Can you use a DDL in a procedure ? How ? Thank you in advance.
(comments are locked)
|
|
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:
(comments are locked)
|
Your answer
