Welcome to your PLSQL Chapter 6 Quiz
1.
What does %TYPE let you do?
2.
What's one difference between Index By Table and Nested Table?
3.
What's wrong with this code (assuming the emp_list exists and the employee table exists)?
FORALL i IN 1 .. emp_list.count LOOP
UPDATE employee
SET years = years + 1
WHERE emp_name = emp_list.emp_name;
END LOOP;
4.
Why should you use BULK COLLECT?
this is good and then the we want these kind of questions more .