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

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

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;