DECLARE 
  CURSOR c2 IS 
    SELECT employee_id, email, employees.manager_id, location_id 
      FROM hr.employees, hr.departments 
        WHERE employees.department_id = departments.department_id; 
 
   join_rec  c2%ROWTYPE;  -- includes columns from two tables 
 
BEGIN 
  NULL; 
END;