Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Collections

 

Extend and count attributes of varray

SQL> SQL> DECLARE   2     TYPE lv_name_array IS VARRAY(5) OF VARCHAR2(10);   3     lv_name_array_rec lv_name_array := lv_name_array('dave','pat','bob');   4  BEGIN   5     FOR lv_loop_num in 1..lv_name_array_rec.COUNT LOOP   6        DBMS_OUTPUT.PUT_LINE(lv_name_array_rec(lv_loop_num));   7     END LOOP;   8     lv_name_array_rec.EXTEND;   9     lv_name_array_rec(lv_name_array_rec.COUNT) := 'tony';  10     DBMS_OUTPUT.PUT_LINE(lv_name_array_rec(4));  11  END;  12  / dave pat bob tony PL/SQL procedure successfully completed. SQL>