Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

loop

end loop; For example:

The previous program can be used as a while as follows declare

temp-Value number;

begin

temp-value := 122 ;

while temp-value <= 131 loop

insert into test values ( temp-value, temp-value * temp-value);

temp-value := temp-value + 1 ;

end loop;

end;