Stationary details are stored in stationary_stock table.

 

Sample data of stationary_stock table is given below.

Download the Table & Data Scripts - Click here to download!

Examine the below PL/SQL code.

DECLARE
TYPE type_stationary IS RECORD
  (
    item_id   NUMBER(4) ,
    item_name VARCHAR2(30),
    price     NUMBER(8,2));
TYPE col_stationary IS TABLE OF type_stationary;
  v_col_stationary col_stationary := col_stationary ();
BEGIN
  SELECT item_id,item_name,price bulk collect INTO v_col_stationary FROM stationary_stock;
  
  FORALL i IN v_col_stationary.FIRST .. v_col_stationary.LAST
  UPDATE stationary_stock SET PRICE =1.25*price WHERE item_id=v_col_stationary(i).item_id;
END;

How many rows will be affected on executing the above code?

To get all PLSQL Assessment Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee