While .. loop of Oracle

OracleLoop statementLoopAndWhileUsage

A. Loop... end
Loop (Execute at least once)

Please write a process. You can enter the user name and add 10 Users to Users in the table, the user number is from 1 .

Create or replace procedureSp_pro6(SpnameVarchar2) isV_num Number: = 1;

Begin

Loop

Insert into users values (V_num,Spname);
--Determine whether to exit the loop

Exit whenV_num= 10;

V_num: =V_num+ 1;

End loop;

End;

B. while loop

Please write a process. You can enter the user name and add 10 Users to Users in the table, the user number is from 11 .

Create or replaceprocedureSp_pro6(SpnameVarchar2) isV_num Number: = 11;

Begin

WhileV_num<21 Loop

Insert into users values (V_num,Spname);

V_num: =V_num+ 1;

End loop;

End;