PL/SQL statement learning uses the while, loop, and for three loops to print 1-10 of the numbers

--1-10--set Serveroutput ondeclare with a while loop to print a number    --Define the loop variable to assign an initial value of 1    pnum numbers: = 1;begin while    pnum<=10 Loop          --Cyclic body          dbms_output.put_line (pnum);          --Make the variable +1          --pnum++; is the wrong wording, Oracle does not support this notation          pnum: = pnum+1;      End Loop;end;  --/

--using loop loop output 1-10--Note loop and while loop opposite declare  pnum number:=1;begin  loop    exit when pnum>10;-- Exit loop loop When Pnum variable is greater than 10    -output loop variable    dbms_output.put_line (pnum);    --cyclic variable self-increment    pnum: = pnum+1;      End loop;end;/

--use for loop to print 1-10--set serveroutput ondeclare    --Define loop variable    pnum number:=1;begin for    pnum in 1..10 loop      Dbms_output.put_line (pnum);      End loop;end;/

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

PL/SQL statement learning uses the while, loop, and for three loops to print 1-10 of the numbers