Database Design DDL & DML
The CALL and EXPLAIN PLAN statements are supported in PL/SQL only when executed dynamically. DDL statements are supported by PL/SQL with the use of the DBMS_SQL package. This command helps you to sets a savepoint within a transaction. It is to be noted that omitting the use where clause results in the emptying of the […]