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 end;
18 /
3
0
PL/SQL procedure successfully completed.
SQL>
|