Quiz 3
-********************************************************- - I create and populate the following table: CREATE TABLE my_employees ( last_name VARCHAR2 (100) , salary NUMBER ) / BEGIN INSERT INTO my_employees VALUES ('Smith', 100); INSERT INTO my_employees VALUES ('Silva', 200); INSERT INTO my_employees VALUES ('Singh', 300); INSERT INTO my_employees VALUES ('Chen', 400); INSERT INTO my_employees VALUES ('Corvalis', 500); INSERT INTO my_employees VALUES ('Feuerstein', 600); COMMIT; END; / I then write the following block: DECLARE TYPE namelist_t IS TABLE OF my_employees.last_name%TYPE; l_filters namelist_t := namelist_t ('S%', 'C%', 'F%'); BEGIN FORALL indx IN 1 .. l_filters.COUNT UPDATE my_employees SET salary = salary * 1.1 WHERE UPPER (last_name) LIKE l_filters