Answers

Question and Answer:

  Home  Oracle Database

⟩ Can DDL Statements Be Used in PL/SQL?

No, you can not run any DDL statements is PL/SQL directly. If you try to use the DROP TABLE statement inside PL/SQL, you will get a compilation error as shown below:

(Connect to XE with SQL*Plus)

BEGIN

DROP TABLE student; -- compilation error

END;

/

 145 views

More Questions for you: