SQL>
SQL>
SQL> declare
2 type myTextTableType is table of varchar2(200) index by binary_integer;
3
4 l_text_table myTextTableType;
5 l_empty_table myTextTableType;
6 begin
7 l_text_table(10) := 'A value';
8 l_text_table(20) := 'Another value';
9 l_text_table(30) := 'Yet another value';
10
11 dbms_output.put_line('We start with ' || l_text_table.count || ' varchar2s ');
12 dbms_output.put_line('-');
13
14 end;
15 /
We start with 3 varchar2s
-
PL/SQL procedure successfully completed.
SQL>
SQL>