Oracle PLSQL Demo - 07.LOOP循环,以EXIT WHEN退出[EXIT in LOOP]

declare
    v_sal number := 6000;
begin

    loop
        v_sal := v_sal + 1;
        dbms_output.put_line(v_sal);
    
        exit when v_sal = 8000;
    
    end loop;
end;

 

posted @ 2015-06-29 22:52  nick_huang  阅读(2445)  评论(0编辑  收藏  举报