Tuesday, 22 May 2012

Can DDL commands be used within a procedure? If so, then how? | PL SQL

 DDL commands, such as create, alter, revoke, and grant, cannot be used directly within the procedural language block. They can only be called using built-in Native Dynamic SQL or Dynamic SQL Package, which allows the execution of the DDL statements at runtime.

No comments: