条件判断语句
有if与case语句
If语句
If语法
If(expression1)then pl/sql_statement
Else
Pl/sql_statement;
End if;
If(expression1)then pl/sql_statement
Else if(expression2)
Pl/sql_statement;
Else
Pl/sql_statement;
End if;
Case语句
从oracle9i以后引入
Case <selector>
When <expression1> then pl/sql_statement1;
When <expression2> then pl/sql_statement2;
…….
[else pl/sql_statement;]
End;
//案例
SQL> declare score number(2) :=80;
2 begin
3 if score>70 then dbms_output.put_line('成绩合格');
4 end if;
5 end;
6 /
SQL> declare score number(2) :=80;
2 begin if score>90 then dbms_output.put_line('成绩合格');
3 else dbms_output.put_line('成绩不合格');
4 end if;
5 end;
6 /
成绩不合格
SQL> declare score number(2):=8;
2 begin
3 case score
4 when 9 then dbms_output.put_line('成绩优秀');
5 when 8 then dbms_output.put_line('成绩亮');
6 end case;
7 end;
8 /