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.
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;