Question: Assignment 5 PLSQL Assignment 2 Notice: be sure to exccute the following command before you start working on the following questions set serveroutput on; 1.
Assignment 5 PLSQL Assignment 2 Notice: be sure to exccute the following command before you start working on the following questions set serveroutput on; 1. Re-do the question 4 of the PL/SOL Assignement 1 by using loop control. Hint: consider using VARRAY. For example DECLARE type gradeCount is varray (5) of integer; gdent gradeCount; type grade is varray (5) of char (1) gd grade: BEGIN gdcnt gradeCount (0,0,0,0,0) END; 2. Type the following anonymous block and execute it. DECLARE sm binary integer -0 i binary integer-0: BEGIN loop ii+1 ifi 10 then exiti end if end loop; dbms output.putline('sum-'I1 sm 11.' END: 3. loop and while loop respectively, and Revise the above program by using for execute them. The revised program should have the same result as the above program
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
