An example of the DELETE method : Table of Number « Collections « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Collections
3. Table of Number

SQL> DECLARE
  2    TYPE numberTabletype IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
  3    myTable numberTabletype;
  4  BEGIN
  5    FOR idx IN 1..10 LOOP
  6      myTable(idx):=(2**idx)+1;
  7    END LOOP;
  8
  9    myTable.DELETE(1);
 10
 11    myTable.DELETE(2,5);
 12
 13    myTable.DELETE;
 14  END;
 15  /

PL/SQL procedure successfully completed.