|
SQL>
SQL> declare
2 type myTextTableType is table of varchar2(200)
3 index by binary_integer;
4
5 myText_table myTextTableType;
6 l_empty_table myTextTableType;
7 begin
8 myText_table(10) := 'A';
9 myText_table(20) := 'AA';
10 myText_table(30) := 'AAA';
11
12 dbms_output.put_line(myText_table.count);
13
14 myText_table.DELETE;
15 dbms_output.put_line(myText_table.count);
16
17 myText_table(15) := 'some text';
18 myText_table(25) := 'some more text';
19 dbms_output.put_line(myText_table.count);
20
21 myText_table := l_empty_table;
22 dbms_output.put_line(myText_table.count);
23
24 end;
25 /
3
0
2
0
PL/SQL procedure successfully completed.
|