The DELETE Table Attribute : Associative Arrays « Collections « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Collections
3. Associative Arrays

SQL> DECLARE
  2    TYPE t_ValueTable IS TABLE OF VARCHAR2(10)
  3      INDEX BY BINARY_INTEGER;
  4    v_Values t_ValueTable;
  5  BEGIN
  6    -- Insert rows into the table.
  7    v_Values(1) := 'One';
  8    v_Values(3) := 'Three';
  9    v_Values(-2) := 'Minus Two';
 10    v_Values(0) := 'Zero';
 11    v_Values(100) := 'Hundred';
 12
 13    v_Values.DELETE(100);  -- Removes 'Hundred'
 14    v_Values.DELETE(1,3);  -- Removes 'One' and 'Three'
 15    v_Values.DELETE;       -- Removes all remaining values
 16  END;
 17  /

PL/SQL procedure successfully completed.

SQL>
SQL>