Question: Evaluate the following: BEGIN FOR i IN 1..10 LOOP IF I=4 OR I=6 THEN null; I:=0; ELSE I:=i+1; INSERT INTO test(result) VALUES (I); END IF;
Evaluate the following:
BEGIN
FOR i IN 1..10 LOOP
IF I=4 OR I=6 THEN null;
I:=0;
ELSE
I:=i+1;
INSERT INTO test(result)
VALUES (I);
END IF;
COMMIT;
END LOOP;
ROLL BACK;
END.
How many values will be inserted into the test table? Blank 1
NB: Write only the number.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help