Live ORACLE

DECLARE
 TYPE deptrectab IS TABLE OF departments%ROWTYPE;
 dept_recs  DEPTRECTAB;
 CURSOR c1 IS
   SELECT department_id,
          department_name,
          manager_id,
          location_id
   FROM   departments
   WHERE  department_id > 70;
BEGIN
 OPEN c1;
 FETCH c1 BULK COLLECT INTO dept_recs;
END;
/  

Bulk-Fetching from a Cursor Into a Collection of Records