Exercise $3\mathrm{.}4$

Write a PL$/$SQL block that will prompt for an employee# number ate runtime. The block will

display the employee# and name, job description, salary and employee manager for all employee

working in the same department number as the input employee, see sample output below:

Enter employee$\_$number: $7788$

No$.$ of staff: $5$

Total salary: R$10875$

$3\mathrm{.}4\mathrm{.}1$ Use BASIC loop with PL$/$SQL variables.

$3\mathrm{.}4\mathrm{.}2$ Use WHILE loop with PL$/$SQL record.

$3\mathrm{.}4\mathrm{.}3$ Use cursor$-$FOR loop

$3\mathrm{.}4\mathrm{.}4$ Use BASIC or WHILE loop with parameter $($the employee# should be treated as

parameter to the cursor.