Collections:
Cannot Use DDL Statements in PL/SQL in Oracle
Can DDL Statements Be Used in PL/SQL in Oracle?
✍: FYIcenter.com
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; /
⇒ Use Variables in SQL Statements in Oracle
⇐ Use DML Statements in PL/SQL in Oracle
2018-10-13, 2083🔥, 0💬
Popular Posts:
How To Present a Past Time in Hours, Minutes and Seconds in MySQL? If you want show an article was p...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...