Table of varchar2 delete all
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 l_text_table.DELETE;
12 dbms_output.put ('After using the DELETE operator, we have ');
13 dbms_output.put_line(l_text_table.count || ' varchar2s ');
14 dbms_output.put_line('-');
15
16 end;
17 /
After using the DELETE operator, we have 0 varchar2s
-
PL/SQL procedure successfully completed.
SQL>
SQL>
Related examples in the same category