Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why Dynamic Sql can execute DDL, while pl/sql directly can't

$a!Jun 12 2016 — edited Jun 12 2016

Hi all,

Why is it that pl/sql code directly can't handle DDL commands, but Dynamic Sql can.

What gives the advantage to the execute immediate that pl/sql code directly can't do.

Regards,

Sail

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 10 2016
Added on Jun 12 2016
8 comments
2,446 views