Write a PL/SQL block that will prompt for an employee number at runtime. The block will display the employee number and name, job description, salary, and employee manager for all employees working in the same department number as the input employee. See sample output below:
Enter employee number: 7788
EMPLOYEE JOB SALARY MANAGER
---------------- --------- ---------- ----------
1. 7788-SCOTT ANALYST 3000 JONES
2. 7902-FORD ANALYST 3000 JONES
3. 7876-ADAMS CLERK 1100 SCOTT
4. 7566-JONES MANAGER 2975 KING
5. 7369-SMITH CLERK 800 FORD
No. of staff: 5
Total salary: R10875
3.4.1 Use BASIC loop with PL/SQL variables.
3.4.2 Use WHILE loop with PL/SQL record.
3.4.3 Use cursor-FOR loop
3.4.4 Use BASIC or WHILE loop with parameter (the employee number should be treated as a parameter to the cursor).