PL/SQL - Exception

A new rule requires all employees with job ID as SH_CLERK (shipping clerk), their minimal salary will be $2,599. Write and run a PL block to go over each employee with job ID as SH_CLERK.

In this anonymous program, we will define a cursor to retrieve employee ID and their salary for those, their job_id = 'SH_CLERK'.

If their salary is equal or greater than 2500, then it is fine;

otherwise, the program will raise an exception as defined Sal_too_low. In this exception handler, print out a message with the info of the employee ID and the current salary amount.