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
Create a procedure named STATUS_SHIP_SP that allows a company to employee in the Shipping Department to update the status of an order to add shipping information. The BB_BASKETSTAT

Project Description: I want to write some SQL statements. The things I need are between pages 5-7. The only problem is that i want it till tomorrow. Skills required is SQL

Great Plains (Microsoft Dynamics) Purchases Report Project Description: I want to build a purchases report that matches the General Ledger. presently, when I join the PM20

ALTER TABLE bb_basketitem ADD CONSTRAINT bitems_qty_ck CHECK (quantity BEGIN INSERT INTO bb_basketitem VALUES (88,8,10.8,21,16,2,3); END; Brewbean’s wants to add a check

Autonomous versus Nested Transactions Though an autonomous transaction is started by the other transaction, it is not a nested transaction for the reasons shown below: (i)

Declaring Exceptions The Exceptions can be declared only in the declarative part of the PL/SQL subprogram, block, or package. By introducing its name, you can declare an excep

This task involves developing some functions that extract data from an SQL database. The scenario is that a company which owns an online vehicle search website wants to generate so

Using Aggregation on Nested Tables Example is the most direct translation of its counterpart in the theory book that can be obtained in SQL but it is so over-elaborate that no

What is Cursors how to use it in Real time application ?

what is the use of declare keyword