Goto statement - syntax, PL-SQL Programming

GOTO Statement 

The GOTO statement branches categorically to a block label or statement label. The label should be exclusive within its scope and should precede a PL/SQL block or an executable statement. The GOTO statement transfers control to the block or the labeled statement.

Syntax:

2047_goto statement.png

Posted Date: 10/8/2012 6:59:12 AM | Location : United States







Related Discussions:- Goto statement - syntax, Assignment Help, Ask Question on Goto statement - syntax, Get Answer, Expert's Help, Goto statement - syntax Discussions

Write discussion on Goto statement - syntax
Your posts are moderated
Related Questions
Using Subqueries A subquery is a query (typically enclosed by parentheses) that appears within another SQL data manipulation statement. If evaluated, the subquery gives a va

Example of NOT EXISTS Operator - SQL Example is a translation into SQL of the corresponding example, which is included there merely to show that for any scalar comparison the

Explicit Cursors The set of rows returned by the query can include zero, one, or multiple rows, depending on how many rows meet your search criteria. Whenever a query returns

Identifiers You use identifiers to name the PL/SQL program items and units that include constants, variables, cursors, exceptions, cursor variables, subprograms, and packages.

At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean's wants to create a trigger that automatically updates the stock level of all pr

Datatype Conversion At times it is necessary to convert a value from one datatype to another. For e.g. if you want to inspect a rowid, you should convert it to a character stri

Using research notes and Oracle documentation plan and execute an upgrade of an installation of Oracle 10g to Oracle 11g release 1. To do this you must show in screen shots and wri

Lightweight system to provide and take info from workers in the field and office, have basic design outlined already just require build and implementation Desired Skills CSS,

IN Mode An IN parameter pass the values to the subprogram being called. Within the subprogram, an IN parameter acts like a constant. And hence, it cannot be assigned a value.

Example of DELETE - SQL As with UPDATE, a FOR PORTION OF clause can be specified if the target table has a defined period name, as illustrated in Example. Example: Deleting