Using a Record Variable

A Brewbean$$s application page is being developed for employees to enter a ID Product number

and view price, quantity $,$ and options etc information for the basket. This program needs to print all column values from the bb$\_$basketitem table. You can ask an IDPRODUCT value from end user or :$=$ assign as $10$

Hint : DECLARE record composite variable via ROWTYPE $\%$ of bb$\_$basketitem table

SELECT $*$ into record

From bb$\_$basketitem

WHERE must have idproduct $=$ &var $($user input to ask which IDPRODUCT$)$

As you notice, there are two records for IDPRODUCT $10...$ Then you need to find a way to print both record one at time$/..$you can use basic loop to fetch each records one by one by usong counter or

Make sure there are $2$ different basketitems records $($Select max$($idbasketitems$))$ for IDPRODUCT $=10$ and do perform FOR LOOP $$ FOR i IN $1.\mathrm{.}2$ and print fields for each records

Up to you