Written Assignment-Printing a Record Using an If

1. Set echo on2. SET SERVEROUT ON3. Set up a spool file to receive your output for submission. I would suggest c:\CSfile\spool.txt _rec)

DECLARE a record variable (Emp_rec) using %ROWTYPE. 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 record7. Add DBMS_OUTPUT lines to print EMPLOYEE_ID, FIRST_NAME, LAST_NAME, and SALARY for the selected record8. Use TO_CHAR to format the salary as $999,9999. Add a EXCEPTION block to report when no data is found10. Compile and run the procedure.11