PL_11DECLARE2e_record_exists EXCEPTION;3PRAGMA_(e_record_exists, -02292);BEGINDBMS_OUTPUT.PUT_LINE('Deleting department 40.');DELETE departments WHERE department_id = 40;7EXCEPTION8WHENTHENDBMS_OUTPUT.PUT_LINE('Cannot delete this department.');10ENDPL_21DECLAREe_name EXCEPTION;BEGINDELETE FROM employees WHERE last_name = 'Higgins';IF SQL%NOTFOUND THENEND IF;7EXCEPTIONWHEN e_name THEN(-20999,8.9.is not a valid last name');10END;

Here, two PL/SQL programs are given. Here we have to fill the blanks in the code.

PL_1 1 DECLARE 2 e_record_exists EXXCEPTION; 3 PRAGMA _(e_record_exists, -02292); 4 BEGIN DBMS_OUTPUT.PUT_LINE('Deleting department 40.'); DELETE departments WHERE department_id = 40; 5 6 7 EXCEPTION 8 WHEN THEN 9 DBMS_OUTPUT.PUT_LINE('Cannot delete this department.'); 10 END

PL_1 1 DECLARE 2 e_record_exists EXXCEPTION; 3 PRAGMA _(e_record_exists, -02292); 4 BEGIN DBMS_OUTPUT.PUT_LINE('Deleting department 40.'); DELETE departments WHERE department_id = 40; 5 6 7 EXCEPTION 8 WHEN THEN 9 DBMS_OUTPUT.PUT_LINE('Cannot delete this department.'); 10 END

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Q: ogram. declare vAddress employee.Address%vRoWTYPE; begin select ename , address into…

A: Given Code: declare vAddress employee.Address%vRoWTYPE; begin select ename , address into…

Q: 3. Create a procedure called DEL_JOB to delete a job from the JOBS table. a. Create a procedure…

A: NOTE: Since you have posted multiple questions and according to our guidelines we are authorized to…

Q: Oracle to create this PL/SQL command : Perform Exception handling and use oracle error table that…

A: It is defined as a unwanted event that interrupts the normal flow of the program. When an exception…

Q: Q7:- Choose the correct statement:- Prints the database_information connection = getDbConnection()…

A: Note: In the question, the numbering given for the statement is wrong. The same number “1” is given…

Q: Question 2 Carorder( orderNo, model, color, price) Lastprinted( DateUsed) Write an anonymous block…

A: Read a car model from the keyboard SELECT model from Carorder; List the ten most expensive orders…

Q: List the OID preﬁxes for which a manager would need to be granted write permission if the manager…

A: A central part of the SNMP protocol is how to name each device attribute in a consistent manner. The…

Q: List the OID preﬁxes for which a manager would need to be granted write permission if the manager…

A: OID implies to an "Object Identifier." It is a location used to extraordinarily distinguish oversaw…

Q: Apex, Salesforce In which you have two types of Record type on Position Object one is for Technical…

A: Given: In which you have two types of Record type on Position Object one is for Technical and one is…