Mega Code Archive
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> --