^{Using Oracle SQL/plus}

Database is HR

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