How can we call DDL statements like CREATE, DROP, TRUNCATE, etc. from PL/SQL?

Correct Answer: EXECUTE IMMEDIATE command can be used to call DDL statements Example: BEGIN EXECUTE IMMEDIATE 'TRUNCATE TABLE employee'; END;

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion