CS4210 Written Assignment-Printing a Record Using an If Statement Points: 45

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. Add If Statement to print record

7. Add DBMS_OUTPUT lines to print EMPLOYEE_ID, FIRST_NAME, LAST_NAME, and SALARY for the selected record

8. Use TO_CHAR to format the salary as $999,999

9. Add a EXCEPTION block to report when no data is found

10. Compile and run the procedure.

11. Close the spool file

12. To upload your completed work, click on the Submit Assignment button.