Exercise 4

Create a PL/SQL block that will prompt the user to input a particular job description and then displays the information below. Make use of UPPER function to avoid data error due to unmatched type of data.

The job code CLERK has 3 employees with total salary of R4150.00