Deleting internal elements from a collection : Nested Tables « Collections « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Collections
3. Nested Tables

SQL>
SQL> declare
  2      type month_nt is table of VARCHAR2(20);
  3      v_month_nt month_nt:=month_nt();
  4      i number;
  5  begin
  6      v_month_nt.extend(3);
  7      v_month_nt(1):='A';
  8      v_month_nt(2):='B';
  9      v_month_nt(3):='C';
 10
 11      v_month_nt.delete(2);
 12      DBMS_OUTPUT.put_line('Count:'||v_month_nt.count);
 13      DBMS_OUTPUT.put_line('Last:'||v_month_nt.last);
 14
 15      i:=v_month_nt.first;
 16      loop
 17          DBMS_OUTPUT.put_line(v_month_nt(i));
 18          i:=v_month_nt.next(i);
 19          if i is null
 20          then
 21              exit;
 22          end if;
 23      end loop;
 24  end;
 25  /
Count:2
Last:3
A
C

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL>