Delete element in table of varchar2
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 l_text_table.DELETE(20);
12 dbms_output.put ('After using the DELETE operator on the second ');
13 dbms_output.put ('record (ie, DELETE(20), we have '||l_text_table.count);
14 dbms_output.put_line(' varchar2s');
15 dbms_output.put_line('-');
16
17 end;
18 /
After using the DELETE operator on the second record (ie, DELETE(20), we have 2 varchar2s
-
PL/SQL procedure successfully completed.
SQL>
SQL>
Related examples in the same category