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; (Solved)

1. 0

2. 99

3. 1

4. 100

  • b. 99
Subscribe Now

Get All Updates & News