Oracle GOTO statement.

Preamble

The GOTO statement calls for code to go to the tag after the GOTO statement.

The syntax for the GOTO statement in Oracle / PLSQL consists of two parts – GOTO statement and LABEL_NAME (transition labels)

The GOTO statement consists of the keyword Goto, followed by LABEL_NAME.

GOTO label_name;
LABEL_NAME

A transition label consists of LABEL_NAME enclosed in << >>, and at least one operator to execute.

<<label_name>>
{...}

• LABEL_NAME must be unique within the code in Oracle / PLSQL.
• It must have at least one operator to be executed after the transition label.

Example:

CREATE OR REPLACE Function FindCourse
( name_in IN varchar2 )
RETURN number
IS
cnumber number;

CURSOR c1
IS
SELECT MAX(course_number)
FROM courses_tbl
WHERE course_name = name_in;

BEGIN

open c1;
fetch c1 into cnumber;

IF c1%notfound then
GOTO default_number;

ELSE .
GOTO increment_number;
END IF;

<<default_number>>
cnumber := 0;

<<increment_number>>
cnumber := cnumber + 1;

close c1;

RETURN cnumber;

END;

PL/SQL; GOTO statement

About Enteros

Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.