Oracle Database Interview Question:

Can DDL Statements Be Used in PL/SQL?

Submitted by: Administrator

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;
/

Submitted by: Administrator