Clear the salaries table by assigning the empty version to it
SQL> SQL> SET ECHO ON SQL> SQL> DECLARE 2 TYPE salary_table IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; 3 4 salaries salary_table; 5 salaries_empty salary_table; 6 BEGIN 7 salaries(20) := 50550; 8 salaries(40) := 50550; 9 salaries(60) := 50550; 10 11 salaries := salaries_empty; 12 END; 13 / PL/SQL procedure successfully completed. SQL> SQL> --