Exercise $3\mathrm{.}2$

Write a PL$/$SQL block using record that will prompt the user to enter employee number. A

message must be displayed back to the user as follows. Make use of $\%$TYPE attributes.

Enter value for employee$\_$no: $7839$

$7369-$SMITH $($CLERK$)$ IS WORKING IN NEW YORK UNDER KING EARNING SALARY OF R$1250\mathrm{.}00$

SINCE $1983$

Exercise $3\mathrm{.}3$

Write a PL$/$SQL block that declare a cursor for all employees working in department $10$ as given

in the following sample output below, Make use of explicit cursor.

$3\mathrm{.}3\mathrm{.}1$ Revise the program code to make use of PL$/$SQL record and include average salary,

maximum salary, and minimum salaries per department.