case条件控制语句
简单的CASE
CASE case_operand
WHEN when_operand1 THEN
statements1;
WHEN when_operand2 THEN
statements2;
...
END CASE;
-------------------------------------------------------------
--when_operand是表达式,结果和case_operand相同则执行statement1;--
-------------------------------------------------------------
搜索式的CASE
CASE
WHEN 布尔表达式1 THEN statement1;
WHEN 布尔表达式2 THEN statement2;
WHEN 布尔表达式3 THEN statement3;
END CASE;
标签:DBMS,END,PLSQL,grade,WHEN,循环,LOOP
From: https://blog.51cto.com/u_16049762/8016570