в 13:45, 26 мая 2010

2010-05-26T13:45:46Z

Admin: 1 версия

2010-05-26T10:05:42Z

1 версия

Новая страница

== An Example of the GOTO Statement==



<source lang="sql">
SQL> DECLARE
2 v_Status NUMBER := 1;
3 BEGIN
4 IF v_Status = 1 THEN
5 GOTO mybranch;
6 ELSE
7 v_Status := 1;
8 END IF;
9 <<mybranch>>
10 NULL;
11 END;
12 /
PL/SQL procedure successfully completed.
SQL></source>

== Demonstrate GOTO==



<source lang="sql">
SQL>
SQL>
SQL> SET SERVEROUTPUT ON
SQL> BEGIN
2 DBMS_OUTPUT.PUT_LINE("BEGINNING OF BLOCK");
3
4 GOTO l_Last_Line;
5
6 DBMS_OUTPUT.PUT_LINE("GOTO didn""t work!");
7 RETURN;
8 <<l_Last_Line>>
9 DBMS_OUTPUT.PUT_LINE("Last Line");
10 END;
11 /
BEGINNING OF BLOCK
Last Line
PL/SQL procedure successfully completed.
SQL></source>

== FOR LOOP with label==



<source lang="sql">
SQL>
SQL> set serveroutput on
SQL> set echo on
BEGIN
FOR v_loopcounter IN 1..5 LOOP
<<insideloop>>
DBMS_OUTPUT.PUT_LINE("Loop counter is " || v_loopcounter);
GOTO insideloop;
END LOOP;

END;
/</source>

== GOTO statement==



<source lang="sql">
SQL>
SQL> set serveroutput on
SQL> set echo on
SQL>
DECLARE
v_Emergency_Warning VARCHAR2(50);
v_Status NUMBER := 0;
BEGIN
<<Emergency_Check>>
BEGIN
IF v_Status = 1 THEN
DBMS_OUTPUT.PUT_LINE("call PANIC(); ");
GOTO Emergency_Check;

END IF;
END;
END;
/</source>

== JUMP out of a IF statement==



<source lang="sql">
SQL>
SQL> set serveroutput on
SQL> set echo on
SQL>
SQL> DECLARE
2 v_Status NUMBER := 1;
3 BEGIN
4 IF v_Status = 1 THEN
5 GOTO mybranch;
6 ELSE
7 v_Status := 1;
8 END IF;
9 <<mybranch>>
10 NULL;
11 END;
12 /
PL/SQL procedure successfully completed.
SQL></source>

== Labels and the GOTO Statement==

The GOTO statement can unconditionally branches to a statement label.
Statement labels are identifiers of a block of code.
Statement labels can be accessed directly by the GOTO statement.



<source lang="sql">
<<label_name>></source>

← Предыдущая	Версия 13:45, 26 мая 2010
(нет различий)

Oracle PL/SQL Tutorial/PL SQL Statements/GOTO - История изменений

в 13:45, 26 мая 2010

Admin: 1 версия