Question: Exercise 12: Write an exception for the following code, that will display a message Employee is not exist if the user entered an employee id

 Exercise 12: Write an exception for the following code, that will

Exercise 12: Write an exception for the following code, that will display a message "Employee is not exist if the user entered an employee id that is not exist. DECLARE nameemployees. LAST NAMESTYPE: emp_idemployees.employee AdXTYPE=&employee id: BEGIN get the employee name by id SELECT last name INTO Lname FROM employees WHERE employee idemed show the employee name dbms output put. Me Employee name is I Loome) END

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!