How does Oracle use circular control keywords exit, goto, continue

 

---

Catalog

1. exit Use

2. goto Use

3. continue Use

4. oracle I won't support it break

---

1. exit Use

---

exit For jumping out of the loop , stay 10g and 11g Can be used normally

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE	10.2.0.1.0	Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
SQL> begin
  2    for i in 1 .. 20 loop
  3      if (i = 5) then
  4        exit;
  5      end if;
  6      dbms_output.put_line(i);
  7    end loop;
  8  end;
  9  /
 
PL/SQL procedure successfully completed

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE	11.2.0.1.0	Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
SQL> begin
  2    for i in 1 .. 20 loop
  3      if (i = 5) then
  4        exit;
  5      end if;
  6      dbms_output.put_line(i);
  7    end loop;
  8  end;
  9  /
 
PL/SQL procedure successfully completed

---

2. goto Use

---

goto Can be in 10g and 11g Use , Some people say 11g It is wrong not to use a proven statement , goto How to use it is as follows

1. <<next_step>> Is a circular label , The name can be customized , For example, the example can also be replaced with <<next>>
2. When using goto next_step When , The program will jump to the defined  <<next_step>> label
3. <<next_step>> Can't follow end loop perhaps exception keyword , So use NULL separate

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE	10.2.0.1.0	Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
SQL> begin
  2  
  3    for i in 1 .. 20 loop
  4      if (i > 5) then
  5        goto next_step;
  6      end if;
  7      dbms_output.put_line(i);
  8  
  9      <<next_step>>  --goto Jump here and enter the next cycle 
 10      NULL;
 11    end loop;
 12  
 13  end;
 14  /
 
PL/SQL procedure successfully completed

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE	11.2.0.1.0	Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
SQL> begin
  2    for i in 1 .. 20 loop
  3      if (i > 5) then
  4        goto next_step;
  5      end if;
  6      dbms_output.put_line(i);
  7  
  8      <<next_step>>  --goto Jump here and enter the next cycle 
  9      NULL;
 10    end loop;
 11  end;
 12  /
 
PL/SQL procedure successfully completed

---

3. continue Use

---

 continue Used to continue the next cycle , continue Keywords are 11g increase , So in Oracle 10g When used in, it will prompt No statement CONTINUE

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE	10.2.0.1.0	Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
SQL> begin
  2    for i in 1 .. 20 loop
  3      --  Judge 
  4      if (i = 5) then
  5        continue;
  6      end if;
  7      dbms_output.put_line(i);
  8    end loop;
  9  end;
 10  /
 
 
ORA-06550: line 6, column 7:
PLS-00201: identifier 'CONTINUE' must be declared
ORA-06550: line 6, column 7:
PL/SQL: Statement ignored

 continue The key word in Oracle 11g Can be used in

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE	11.2.0.1.0	Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
SQL> begin
  2    for i in 1 .. 20 loop
  3      --  Judge 
  4      if (i = 5) then
  5        continue;
  6      end if;
  7      dbms_output.put_line(i);
  8    end loop;
  9  end;
 10  /
 
PL/SQL procedure successfully completed

---

4. oracle I won't support it break

---

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE	10.2.0.1.0	Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
SQL> begin
  2    for i in 1 .. 20 loop
  3      --  Judge 
  4      if (i = 5) then
  5        break;
  6      end if;
  7      dbms_output.put_line(i);
  8    end loop;
  9  end;
 10  /
 

ORA-06550: line 6, column 7:
PLS-00201: identifier 'BREAK' must be declared
ORA-06550: line 6, column 7:
PL/SQL: Statement ignored

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE	11.2.0.1.0	Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
SQL> begin
  2    for i in 1 .. 20 loop
  3      --  Judge 
  4      if (i = 5) then
  5        break;
  6      end if;
  7      dbms_output.put_line(i);
  8    end loop;
  9  end;
 10  /
 
ORA-06550:  The first  6  That's ok ,  The first  7  Column : 
PLS-00201: identifier 'BREAK' must be declared
ORA-06550:  The first  6  That's ok ,  The first  7  Column : 
PL/SQL: Statement ignored

Last one ：Oracle 10g How to modify user name