CURSOR basketitem_curIS
SELECT idproduct, quantity, option1
FROM bb_basketitem
WHERE idbasket = :NEW.idbasket;
In the code fragment above, which of the following represents the correlation identifier?
A) idproduct
B) bb_basketitem
C) quantity
D) :NEW.idbasket

Question

Quizplus · Accepted Answer

:NEW.idbasket is the correlation identifier because it is used to correlate the data from the bb_basketitem table with the corresponding basket in the outer query.

CURSOR Basketitem_curIS SELECT Idproduct, Quantity, Option1