Basic Oracle Concepts and Programming Question: Download Oracle Database PDF
Can DDL Statements Be Used in PL/SQL?
Answer:
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;
/
(Connect to XE with SQL*Plus)
BEGIN
DROP TABLE student; -- compilation error
END;
/
| Previous Question | Next Question |
| Can DML Statements Be Used in PL/SQL? | Can Variables Be Used in SQL Statements? |