This Oracle tutorial explains how to use the GOTO statement in Oracle with syntax and examples.
The GOTO statement causes the code to branch to the label after the GOTO statement.
The syntax for the GOTO statement in Oracle/PLSQL consists of two parts - the GOTO statement and the Label Declaration:
The GOTO statement consists of the GOTO keyword, followed by a label_name.
The Label Declaration consists of the label_name encapsulated in << >>, followed by at least one statement to execute.
- label_name must be unique within the scope of the code.
- There must be at least one statement to execute after the Label Declaration.
Let's look at an Oracle example that uses the GOTO statement.
CREATE OR REPLACE Function FindCourse
( name_in IN varchar2 )
WHERE course_name = name_in;
fetch c1 into cnumber;
IF c1%notfound then
cnumber := 0;
cnumber := cnumber + 1;
In this GOTO example, we have created two GOTO statements. The first one is called default_number and the second one is called increment_number.