oracle条件控制和循环（oracle循环控制语句有哪3种）

oracle条件控制和循环

--结构控制

If no=95002 then
Insert into table value(name,birthday);
End if

------------------

If no=95002 then
    Insert into table value(name,birthday);
Else
    Insert into table_no value(name,birthday);
End if

------------------

If score>90 then
  Score:=score-5;
Elsif score<60 then
  Score:=score+5;
End if

--------Example:在一个三人组中根据学生姓名查找学生证号

Declare
    V_studentname varchar(20)=’wenjuan shao’;
    V_num varchar2(50);
begin
V_num:=case v_studentname
    When ‘xianli jin’ then ‘015856’;
    When ‘wen jin’ then ‘015857’;
    When ‘de jin’ then ‘015858’;
Else ‘no student’
Dbms_output.putline(v_num);
End;

------------------ 循环结构

For control in 0..5 loop
Null;
End loop;

------------------

for I in 10..20 then
dbms_output.put_line(i);
end loop

------------------

Control_var:=0;
While control_var<=5 loop
Control_var:=control_var+1;
End loop

------------------

Control_var:=0;
Loop
Exit when control_var>5
Control_var:=control_var+1;
End loop

------------------

Control_var:=0;
Loop
  If control_var>5 then
    Exit;
  End if
    Control_var:=control_var+1;
End loop;

2021-7-29