View difference between Paste ID: hwi4GX9C and A9fDm9Ap

 DECLARE
-TYPE t_country_names IS TABLE OF wf_countries.country_name%TYPE
+  TYPE t_country_names IS TABLE OF
-INDEX BY BINARY_INTEGER;
+                 wf_countries.country_name%TYPE
-v_country_names      t_country_names;
+                 INDEX BY BINARY_INTEGER;
-CURSOR country_curs IS
+  v_country_names      t_country_names;
-SELECT country_id, country_name
+  CURSOR country_curs IS
-FROM wf_countries
+    SELECT country_id, country_name
-WHERE region_id = 5
+      FROM wf_countries
-ORDER BY country_id;
+      WHERE region_id = 5
-v_country_rec country_curs%ROWTYPE;
+      ORDER BY country_id;
   v_country_rec       country_curs%ROWTYPE;
-OPEN country_curs;
+
-LOOP
+  OPEN country_curs;
-FETCH country_curs INTO v_country_rec;
+  LOOP
-EXIT WHEN country_curs%NOTFOUND;
+    FETCH country_curs INTO v_country_rec;
-v_country_names(v_country_rec.country_id) :=  v_country_rec.country_name;
+    EXIT WHEN country_curs%NOTFOUND;
-END LOOP;
+    v_country_names(v_country_rec.country_id) :=
-CLOSE country_curs;
+                         v_country_rec.country_name;
   END LOOP;
   CLOSE country_curs;
   FOR i IN v_country_names.FIRST .. v_country_names.LAST
   LOOP
     IF v_country_names.EXISTS(i) THEN
       DBMS_OUTPUT.PUT_LINE(i || ' ' || v_country_names(i));
     END IF;
   END LOOP;
 END;