SQL>
SQL>
SQL> declare
2 l_names dbms_sql.varchar2_table;
3 begin
4 l_names(1) := 'W';
5 l_names(2) := 'J';
6 l_names(3) := 'C';
7
8 for idx in 1 .. l_names.COUNT loop
9 dbms_output.put_line('Name (' || idx || ') is ' || l_names(idx));
10 end loop;
11 end;
12 /
Name (1) is W
Name (2) is J
Name (3) is C
PL/SQL procedure successfully completed.
SQL>
|