Home / Engineering / Database Management System (DBMS) / Question

M

Mr. Dubey • 51.17K Points
Coach

Q.) In the PL/SQL block below, how many rows will be inserted in the messages table? DECLARE v_start_salesNUMBER := 2; v_end_sales NUMBER := 100; BEGIN FOR i IN v_start_sales..v_end_sales LOOP INSERT INTO messages(msgid) VALUES v_start_sales; END LOOP; END;

(A) 0
(B) 99
(C) 1
(D) 100
Correct answer : Option (B) - 99

Share

Discusssion

Login to discuss.