SQL> DECLARE
  2  Emp_rec HR.EMPLOYEES%ROWTYPE;
  3  BEGIN
  4  SELECT *
  5  INTO Emp_rec
  6  FROM HR.EMPLOYEES
  7  WHERE DEPARTMENT_ID=30.7;
  8  IF Emp_rec.DEPARTMENT_ID=30.7 THEN
  9  DBMS_OUTPUT.Put_line( 'DEPARTMENT_ID:' ||  Emp_rec.Department_id);
 10  DBMS_OUTPUT.Put_line( 'EMPLOYEE_ID:' || Emp_rec.Employee_id);
 11  DBMS_OUTPUT.Put_line( 'FIRST_NAME:' || Emp_rec.First_name);
 12  DBMS_OUTPUT.Put_line( 'LAST_NAME:' || Emp_rec.Last_name);
 13  DBMS_OUTPUT.Put_line( 'SALARY:' || TO_CHAR(Emp_rec.Salary,'$999,999'));
 14  END IF;
 15  EXCEPTION
 16  WHEN NO_DATA_FOUND THEN
 17  DBMS_OUTPUT.Put_line( 'NO DATA FOUND.');
 18  END;
 19  /
NO DATA FOUND.                                                                  

PL/SQL procedure successfully completed.

SQL> SPOOL OFF