A GOTO Statement in Oracle PLSQL is used to redirect the code execution to a “Label” as specified in the GOTO statement.
Syntax of the GOTO Statement in Oracle PLSQL is:
GOTO label_name;
Somewhere further in the code, we need to place the label “label_name” and provide the code to be executed.
Example of GOTO in Oracle PLSQL is:
GOTO techhoney; techhoney: { statements; }
Jan Hejda 'blog says
Thanks a lot for sharing this with all of us you really know what you are talking about! Bookmarked. Please also visit my web site =). We could have a link exchange agreement between us!
Xavier says
However, there are many limitations to their use …