Print a single formatted record

1- Set echo on

2- Set up a spool file to receive your output . I would suggest c:\cs4210\WA4spool.txt .

3- SET SERVEROUTPUT ON

5- DECLARE a record variable (Emp_rec) using %ROWTYPE

6- In the BEGIN block use INTO to load a record into the declared variables for HR.EMPLOYEES for Employee_ID = 114

7- Use a CASE statement to print the associated Department Name for Department_ID

8- Add DBMS_OUTPUT lines to print each variable for the selected record

9- Use TO_CHAR to format Salary as 999,999.00

10- Add an EXCEPTION block to report when no data is found

11- Compile and run the procedure

12- Close the spool file