Demonstrate Associative Arrays : Table of Varchar2 « Collections « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Collections
3. Table of Varchar2

SQL> declare
  2    type varchar_array is table of varchar2(100) index by binary_integer;
  3    array1  varchar_array;
  4    v_index number;
  5  begin
  6    array1(1) := 'T';
  7    array1(2) := 'R';
  8    array1(5) := 'B';
  9
 10    v_index := array1.first;
 11
 12    for x in 1..array1.count loop
 13      dbms_output.put_line(array1(v_index) );
 14      v_index := array1.next(v_index);
 15    end loop;
 16  end;
 17  /

PL/SQL procedure successfully completed.

SQL>
SQL>