Clear the table of varchar2
SQL>
SQL> -- delete Pl/SQL table records
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
12 l_text_table := l_empty_table;
13 dbms_output.put ('Once we assign our populated table to an empty ');
14 dbms_output.put_line('table, we end up with ' || l_text_table.count);
15 dbms_output.put_line(' varchar2s ');
16
17 end;
18 /
Once we assign our populated table to an empty table, we end up with 0
varchar2s
PL/SQL procedure successfully completed.
SQL>
Related examples in the same category