Write Stored Procedure Uses Loop Print Integers 1 5 Write Stored Procedure Loop Print Inte Q37106080

1. Write a stored procedure that uses the while loop to print theintegers between 1 and 5
2. Write a stored procedure that the for loop to print the integerbetween 1 and 5 (hint: FOR i IN 1..5)

NOTE: Can you provide the screenshot of the answers of theprogram?

Solution

the following is a screenshot in pl/SQL:

It consists of two stored procedure one with for loop andanother with while loop

copyable code:

CREATE OR REPLACE PROCEDURE while_disp /*creating aprocedure*/
IS   
a number(2) := 1; /*intialising a to 1*/
BEGIN
WHILE a <=5

OR

 

OR