PL/SQL 支持不同方式的条件判断,主要分为2大类:
- IF
- CASE
#IF
##IF-THEN
condition求值为TRUE,sequence_of_statements将会执行。
IF condition THEN
sequence_of_statements;
END IF;
##IF-THEN-ELSE
condition求值为TRUE,sequence_of_if_statements将会执行,否则执行sequence_of_else_statements。
IF condition THEN
sequence_of_if_statements;
ELSE
sequence_of_else_statements;
END IF;
##IF-THEN-ELSEIF
condition1求值为TRUE,sequence_of_if_statements1将会执行,否则如果condition2求值为TRUE,sequence_of_statements2将会执行,否则执行sequence_of_statements3。
IF condition1 THEN
sequence_of_statements1
ELSIF condition2 THEN
sequence_of_statements2
ELSE
sequence_of_statements3
END IF;
最后的 ELSE
为可选的,在IF结构内可以有任意多个ELSEIF