5- What is the output of the following PL/SQL block?
DECLARE
a INTEGER := 10;BEGIN
WHILE a < 16 LOOP
dbms_output.put_line(‘Value of a is ‘ || a ); a := a + 2;
END LOOP;END ;
6- What is the output of the following PL/SQL block?
DECLARE
c INTEGER := 0; R INTEGER;BEGIN
FOR a IN 1..2 LOOP
FOR b IN 1..3 LOOP
R := (a + b) * c; dbms_output.put_line(‘Result = ‘ || R); c := c+ 1;
END LOOP;END LOOP;
END ;
7- Consider the Branch table with the following datainstance.
What is the output of the following PL/SQL block?
DECLARE
vBranchNo VARCHAR(4); vAddress VARCHAR(25);CURSOR branchCursorIS
SELECT branchNo,address FROM BranchWHERE city = ‘Boston’;
BEGIN
OPEN branchCursor;
LOOP
FETCH branchCursor INTO
OR
OR