DECLARE

TYPE dept_table_type IS TABLE OF
     departments.department_name%TYPE 
     INDEX BY PLS_INTEGER ;
 my_dept_table   dept_table_type ;
 f_loop_count    NUMBER(2):=10;
 v_deptno        NUMBER(4):=0;

BEGIN
 FOR i IN 1..f_loop_count
 LOOP    
  v_deptno := v_deptno+10 ;
  SELECT department_name INTO my_dept_table(i)
  FROM departments
  WHERE department_id = v_deptno ;
 END LOOP;

 FOR i IN 1..f_loop_count
 LOOP
  DBMS_OUTPUT.PUT_LINE (my_dept_table(i));
 END LOOP;
END;