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
to write a heap sort program usin pl-sql

Defining Autonomous Transactions To define an autonomous transaction, you use the pragma (compiler directive) AUTONOMOUS_TRANSACTION. The pragma instructs the PL/SQL compiler

Quantification in SQL To quantify something, as the theory book has it, is to state its quantity, to say how many of it there are. For example, in Tutorial D the expression CO

Using Cursor Attributes: Every cursor has 4 attributes: %NOTFOUND, %FOUND, %ISOPEN, and %ROWCOUNT. If appended to the cursor name, they return the helpful information about

Updating Tables in SQL The topic of updating by describing the assignment operator, ":=" in Tutorial D. SQL uses a different syntax for assignment, using the key word SET and

Scoping Within the similar scope, all the declared identifiers should be unique. So, even if their datatypes differ, the variables and parameters cannot share the similar name.

JOIN and AND in SQL In this Section is all about one operator, JOIN. SQL's closest counterpart, NATURAL JOIN, has already been covered. Here we look at several other "join" op

Example of Using Aggregation on Nested Tables Example: How many students sat each exam WITH C_ER AS (SELECT CourseId, CAST (TABLE (SELECT DISTINCT StudentId, Mark FROM EXAM

Parameter and Keyword Description: collection_name: This keyword identifies the index-by table, nested table, or varray formerly declared within the present scope. cu

Information Hiding   With the information hiding, you see only the details that are significant at a given level of algorithm and data structure design. The Information hiding