GOTO | PL/SQl

Analyze Code

Page Index

PL/SQL Introduction

Getting Started
PL/SQL Variables
PL/SQL Constant

Control Statements

PL/SQL IF
PL/SQL Case
PL/SQL Loop
PL/SQL ExitLoop
PL/SQL WhileLoop
PL/SQL For Loop
PL/SQL Continue
PL/SQL GOTO

PLSQL Concepts

PL/SQL Procedure
PL/SQL Function
PL/SQL Cursor
PL/SQL Exception
PL/SQL Trigger

GOTO in PL/SQL

In PL/SQL, GOTO statement makes you able to get an unconditional jump from the GOTO to a specific executable statement label in the same subprogram of the PL/SQL block.

Here the label declaration which contains the label_name encapsulated within the << >> symbol and must be followed by at least one statement to execute.

Syntax of GOTO: GOTO label_name;

Example of GOTO in loop

After executing this , the output is

Let's learn procedures in PL/SQL

PL/SQl Continue

PL/SQL Procedures

Share this page on :