Oracle cyclic statement triggers

In Oracle, loop www.2cto.com is the simplest loop statement in plsql. This loop statement starts with loop and ends with end loop, this loop will be executed at least once, that is, the first loop is used to judge the case: Write a process, enter the user, and add 10 users to the user table cyclically, create or replace procedure chenchuang2 (name varchar2) is -- Definition: = indicates the value of v_num number: = 1; begin loop insert into users values (v_num, name ); -- determine whether to exit the loop exit where v_num: = 10; v_num: = v_num + 1; end loop; end; www.2cto.com contains loop statement --- while loop while is used in the same way as in java, first judge create or replace procedure chenchuang2 (name varchar2) is -- Definition: = indicates the value of v_num number: = 11; begin while v_num <= 20 loop insert into users values (v_num, name); -- determine whether to exit loop exit where v_num: = 10; v_num: = v_num + 1; end loop; end ;----------------------------------------------------------