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:
1 | GOTO techhoney; |
2 | techhoney: |
3 | { |
4 | statements; |
5 | } |