PLSQL - variable at the end of the Loop Statement

Question

I was reviewing a colleague's code and found something similar below:

begin
    for i in (select 'x' from dual) loop
        null;
    end loop Y; 
end;

I can't understand why this compiles and runs. Shouldn't it fail because of the "Y" variable? I tried other variables as well but it compiles.

please advise.

Thank you.

Gnqz · Accepted Answer · 2022-06-03 15:43:00Z

3

These are just statement labels and exist to name a particular part of the program, it's not much different from the label you put after the begin end of a procedure to mark the end of the procedure.

For reference

edited Jun 3, 2022 at 15:43

answered Jun 3, 2022 at 7:59

Gnqz

3,3823 gold badges28 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

kfinity Over a year ago

Your reference link is for MySQL, here's one for Oracle db: docs.oracle.com/en/database/oracle/oracle-database/21/lnpls/…

Gnqz Over a year ago

Silly me, thank you for the remark, adjusted it.

Collectives™ on Stack Overflow

PLSQL - variable at the end of the Loop Statement

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related