Deleting an Index-by table using an empty Index-by table : 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    myTable1 numberTabletype;
  4    myTable2 numberTabletype;
  5    v_num NUMBER :=13;
  6  BEGIN
  7    myTable1(1):=1001;
  8    myTable1(10):=1002;
  9    myTable1(-10):=1003;
 10    myTable1(v_num):=1004;
 11    myTable1:=myTable2;
 12  END;
 13  /

PL/SQL procedure successfully completed.