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 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
Get step-by-step solutions from verified subject matter experts
