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
Find the account numbers of all customers whose balance is more than 10,000 $

Use the RETURNING Clause Frequently, the application requires information about the row affected by a SQL operation, for illustration, to produce a report or take a subsequent

UNION ALL - SQL Further varieties of UNION arise when we replace the key word DISTINCT by ALL in any of the foregoing examples, as in Example. ALL specifies that if row r appe

RETURN Statement The RETURN statement instantly completes the execution of a subprogram and returns control to the caller. The Execution then resumes with the statement below t

Write an anonymous block that contains a PL/SQL procedure. The procedure takes two input parameter: oldZip and newZip, and it updates the zipcodes table by replacing all oldZip wit

Using PRIOR and NEXT The PRIOR(n) returns the index number that precede index n in a collection. The NEXT(n) returns the index number which succeed the index n. If n has no pr

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

Brewbean's is implementing a new discount for return shoppers - every fifth completed order receives a 10% discount. The count of orders for a shopper is placed in a packaged varia

Using a join on 2 tables, select all columns and 10 rows from the 2 tables without the use of a Cartesian product. Query: SELECT * FROM EMPLOYEE1 E JOIN STAFF S ON E.EMP_

Operator Precedence The operations within an expression are completed in a particular order depending on their precedence (priority). The table shows the default order of the op