Notice: be sure to execute the following command before you start working on the following

questions.

set serveroutput on;

1. Re-do the question 4 of the PL/SQL Assignement 1 by using loop control.

Hint: consider using VARRAY. For example

DECLARE

type gradeCount is varray(5) of integer;

gdcnt gradeCount;

type grade is varray(5) of char(1);

gd grade;

BEGIN

gdcnt := gradeCount(0,0,0,0,0);

gd := grade(A, B, C, D, F);

END;

2. Type the following anonymous block and execute it.

DECLARE

sm binary_integer :=0;

i binary_integer :=0;

BEGIN

loop

i := i + 1;

if i > 10 then

exit;

end if;

sm := sm + i;

end loop;

dbms_output.put_line('sum= ' || sm || '.');

END;

3. Revise the above program by using for loop and while loop respectively, and

execute them. The revised program should have the same result as the above program.