  DECLARE
   TYPE tabtype IS TABLE OF city%ROWTYPE;
   tab tabtype;
  BEGIN
   SELECT *
    BULK COLLECT INTO tab
    FROM city
    WHERE country = 'D';
   FOR i IN tab.FIRST .. tab.LAST LOOP
    dbms_output.put_line(tab(i).name);
   END LOOP;
  END;
  /
