一 定义:
The Oracle PL/SQL GOTO statement is a sequential control structure available in Oracle. The GOTO statement immediately transfers program control (called "branching") unconditionally to a named statement label or block label. The statement or label name must be unique in the block.
属于plsql控制语句,用于程序控制非条件跳至指定标签<<???>>。不易控制和维护,慎用!
二 例子:
1、简单GOTO 语句,判断数字是否为质数:
?
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
DECLARE |
2、使用null避免报错:
?
1 2 3 4 5 6 7 8 9 10 11 12 |
DECLARE |
3、使用goto分出一个环绕块:
?
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
-- example with GOTO statement |
----------------------
dylan presents.