Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

GOTO

GOTO label_name;

Performs unconditional branching to a named label. In general, use of the GO statement is not recommended. At least one executable statement must follow the label (if you wish, the NULL statement can be this necessary executable statement).

Restrictions

The following scope restrictions apply to the GOTO statement:

  • Can branch out of an IF statement, LOOP, or sub-block

  • Cannot branch into an IF statement, LOOP, or sub-block

  • Cannot branch from one section of an IF statement to another (from the IF/THEN section to the ELSE section is illegal)

  • Cannot branch into or out of a subprogram

  • Cannot branch from the exception section to the executable section of a PL/SQL block

  • Cannot branch from the executable section to the exception section of a PL/SQL block, although a RAISE does this

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page