Oracle 11g管理与编程基础 教学课件 作者 王鹏杰 王存睿 郑海旭 Chapt11 PLSQL基础.pptVIP

* * * * * * * * … * 请结合脚本运行录制pdf文档授课，很多plsql程序的例子无法在课件ppt上展示，这些都在脚本运行录制pdf文档上。 IF-THEN-ELSE语句 if ab then maxValue:=a; Else maxValue:=b; End if; IF-THEN-ELSIF语句 If a is NULL or b is NULL then dbms_output.put_line(‘有一个值为空’); Elsif ab then maxValue:=a; Else maxValue:=b; End if; PL/SQL控制结构（条件控制续1） Declare grade binary_integer:=90; begin if grade between 90 and 100 then dbms_output.put_line(‘优秀’); elsif grade between 80 and 89 then dbms_output.put_line(‘良好’); elsif grade between 70 and 79 then dbms_output.put_line(‘中等’); elsif grade between 60 and 69 then dbms_output.put_line(‘及格’); elsif grade between 0 and 59 then dbms_output.put_line(‘不及格’); end if; End; PL/SQL控制结构（条件控制续2） 普通case语句语法： Case selector when expression1 then statement1; when expression2 then statement2; ...... when expressionN then statementN; [else statementN+1;] End case Declare grade binary_integer:=90; Begin case grade when between 90 and 100 then dbms_output.put_line(‘优秀’); when between 80 and 89 then dbms_output.put_line(‘良好’); when between 70 and 79 then dbms_output.put_line(‘中等’); when between 60 and 69 then dbms_output.put_line(‘及格’); when between 0 and 59 then dbms_output.put_line(‘不及格’); else dbms_output.put_line(‘没有此成绩’); end case; End; PL/SQL控制结构（条件控制续3） PL/SQL控制结构（条件控制续4） 搜索case语句语法： Case when condition1 then statement1; when condition2 then statement2; … when conditionN then statementN; [else statementN+1;] END CASE PL/SQL控制结构（条件控制续5） Declare grade binary_integer:=90; Begin case when grade between 90 and 100 then bms_output.put_line(‘优秀’); when grade between 80 and 89 then dbms_output.put_line(‘良好’); when grade between 70 and 79 then dbms_output.put_line(‘中等’); when grade between 60 and 69 then dbms_