Assing an empty table record to non-empty table record
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.