oracle 循环语句总结:
1、Exit When循环:
- create or replace procedure proc_test_exit_when is
- i number;
- begin
- i:=0;
- LOOP
- Exit When(i>5);
- Dbms_Output.put_line(i);
- i:=i+1;
- END LOOP;
- end proc_test_exit_when;
create or replace procedure proc_test_exit_when is
i number;
begin
i:=0;
LOOP
Exit When(i>5);
Dbms_Output.put_line(i);
i:=i+1;
END LOOP;
end proc_test_exit_when;
2、Loop循环:
- create or replace procedure proc_test_loop is
- i number;
- begin
- i:=0;
- loop
- i:=i+1;
- dbms_output.put_line(i);
- if i>5 then
- exit;