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, 1477🔥, 0💬
Popular Posts:
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...