BEGIN
   UPDATE preferences
      SET ice_cream_flavor = 'CHOCOLATE'
    WHERE name = 'STEVEN'; 

DECLARE
   CURSOR around_the_house_jobs_cur
   IS
       SELECT job, frequencey
         FROM adolescent_workload
        WHERE name = 'ELI'; 

DECLARE
   next_key employee.employee_id%TYPE;
BEGIN
   SELECT employee_seq.NEXTVAL
     INTO next_key
     FROM dual; 

FORALL indx IN my_collection.FIRST .. my_collection.LAST
   DELETE FROM employees
    WHERE employee_id = my_collection(indx);