What does %TYPE let you do?
What's one difference between Index By Table and Nested Table?
What's wrong with this code (assuming the emp_list exists and the employee table exists)?
FORALL i IN 1 .. emp_list.count LOOP
SET years = years + 1
WHERE emp_name = emp_list.emp_name;
Why should you use BULK COLLECT?