Following the example in Lecture 5 (most of this is identical to Written Assignment 4) 1. Set echo on 2. SET SERVEROUT ON 3. Set up a spool file to receive your output for submission. I would suggest c:\CS4210\wa5spool.txt . 4. DECLARE a record variable (Emp_rec) using %ROWTYPE 5. In the BEGIN block add a select statement to read a record into the declared variable from HR.EMPLOYEES 6. for all employees WHERE DEPARTMENT_ID = 30 7. Add a LOOP to print all the records 8. Add DBMS_OUTPUT lines to print EMPLOYEE_ID, FIRST_NAME, LAST_NAME, and SALARY for the selected record 9. Use TO_CHAR to format the salary as $999,999 10. Add a EXCEPTION block to report when no data is found 11. Compile and run the procedure. 12. Close the spool file