• Skip to primary navigation
  • Skip to main content

Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

  • Home
  • HTML
    • Tags in HTML
    • HTML Attributes
  • OA Framework
    • Item in OAF
    • Regions in OAF
    • General OAF Topics
  • Oracle
    • statement
    • function
    • clause
    • plsql
    • sql
You are here: Home / Oracle / statement / GOTO Statement in Oracle PLSQL

GOTO Statement in Oracle PLSQL

November 23, 2012 by techhoneyadmin

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;
}

Filed Under: statement Tagged With: GOTO Statement in oracle plsql, GOTO Statement in oracle sql, GOTOSTATEMENTPLSQL, how to use GOTO Statement in oracle database query, how to use GOTO Statement in oracle plsql, how to use GOTO Statement in oracle sql, syntax and example of GOTO Statement in oracle database query, syntax and example of GOTO Statement in oracle plsql, syntax and example of GOTO Statement in oracle sql, using GOTO Statement in oracle database query, using GOTO Statement in oracle plsql, using GOTO Statement in oracle sql

Reader Interactions

Comments

  1. Jan Hejda 'blog says

    November 24, 2012 at 11:03 pm

    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!

  2. Xavier says

    November 27, 2012 at 1:39 pm

    However, there are many limitations to their use …

Copyright © 2023 · Parallax Pro on Genesis Framework · WordPress · Log in