小布老师-PL_SQL(第十讲)

一、For 循环 for i in 1..3  中i 包含上下界即包含1、3； for i in reverse 1..3

二、退出循环

         BEGIN

                 <<Outer_loop>>

                loop 

                       v_counter := v_counter+1;

                       EXIT WHEN        V_COUNTER >10;

                       <<INNER_LOOP>>

                       LOOP

                            .......

                             EXIT Outer_loop When total_done = 'YES';

                               -----leave booth loops

                             Exit   when inner_done = 'YES';

                              ------leave inner loop only

                        end LOOP   INNER_LOOP;

                   END LOOP Outer_loop;

              END;

三、continue 只在11g中使用；

              DECLARE

                         V_TOTAL NUMBER := 0;

              BEGIN

                      << BEFORETOPLOOP>>

                      FOR   I   IN   1..10  LOOP

                                    V_TOTAL :=  V_TOTAL +1;

                                     DBMS_OUTPUT.PUT_LINE('TOTAL  IS   : ' || V_TOTAL);

                                     FOR  J  IN  1...10 LOOP

                                                 CONTINUE  BEFORETOPLOOP  WHEN    I+J > 5;

                                                   V_TOTAL := V_TOTAL +1;

                                     END LOOP;

                        END  LOOP;

              END TWO_LOOP;

四、有GOTO语句；null;语句