Section B - EXCEPTION HANDLING TASK 1 Write a PL/SQL block to retrieve employees from the ENEW table based on their sala

[answerhappygod]

Section B Exception Handling Task 1 Write A Pl Sql Block To Retrieve Employees From The Enew Table Based On Their Sala 1 (38.75 KiB) Viewed 44 times

Before you begin, create the ENEW table using the following statement:
CREATE TABLE ENEW AS SELECT * FROM EMP;
Section B - EXCEPTION HANDLING TASK 1 Write a PL/SQL block to retrieve employees from the ENEW table based on their salary. If there are multiple employees earning the same salary (i.e. returns more than one row), handle the exception with the appropriate handler and print the message "More than one employee with the same salary". If there are no employees earning that salary, handle the exception with the appropriate handler and display the message "No employees with this salary". If there is only one employee with this salary, then print that employee's name, hiredate and salary (predefined server exception problem).