SET SERVEROUT ON
spool c:\CS4210\wa5spool.txt 
DECLARE
    Emp_rec   HR.EMPLOYEES%ROWTYPE;
BEGIN
    SELECT *
    INTO Emp_rec
    FROM HR.EMPLOYEES
    WHERE DEPARTMENT_ID=30.7;

    IF Emp_rec.DEPARTMENT_ID = 30.7 THEN
        DBMS_OUTPUT.Put_line('DEPARTMENT_ID: ' || Emp_rec.Department_id);
        DBMS_OUTPUT.Put_line('EMPLOYEE_ID:' || Emp_rec.Employee_id);
        DBMS_OUTPUT.Put_line('FIRST_NAME: ' || Emp_rec.First_name);
        DBMS_OUTPUT.Put_line('LAST_NAME: ' || Emp_rec.Last_name);
        DBMS_OUTPUT.Put_line(
            'SALARY: ' || TO_CHAR(Emp_rec.Salary, '$999,999'));
    END IF;
EXCEPTION
    WHEN NO_DATA_FOUND THEN
        DBMS_OUTPUT.Put_line('NO DATA FOUND.');
END;
/

spool off