oraclegoto语句介绍
- WBOY原创
- 2016-06-07 14:54:061512浏览
TheOraclePL/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
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
p VARCHAR2(30);
n PLS_INTEGER := 37; -- test any integer > 2 for prime
BEGIN
FOR j IN 2 .. round(sqrt(n)) LOOP
IF n MOD j = 0 THEN
-- test for prime
p := ' is not a prime number'; -- not a prime number
GOTO print_now;
END IF;
END LOOP;
p := ' is a prime number';
>
dbms_output.put_line(to_char(n) || p);
END;
/
2、使用null避免报错：
1
2
3
4
5
6
7
8
9
10
11
12
DECLARE
done BOOLEAN;
BEGIN
FOR i IN 1 .. 50 LOOP
IF done THEN
GOTO end_loop;
END IF;
> -- not allowed unless an executable statement follows
NULL; -- add NULL statement to avoid error
END LOOP; -- raises an error without the previous NULL
END;
/
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
DECLARE
v_last_name VARCHAR2(25);
v_emp_id NUMBER(6) := 120;
BEGIN
>
SELECT last_name
INTO v_last_name
FROM employees
WHERE employee_id = v_emp_id;
BEGIN
dbms_output.put_line(v_last_name);
v_emp_id := v_emp_id + 5;
IF v_emp_id
GOTO get_name; -- branch to enclosing block
END IF;
END;
END;
/
----------------------