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:

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

Ask an Expert

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

Write your message here..

Related Questions

Loop labels- iterative control, Loop Labels Like the PL/SQL blocks, loop... Loop Labels Like the PL/SQL blocks, loops can also be labeled. The label, an undeclared identifier enclosed by double angle brackets, should appear at the beginning of the LOOP

Using exception_init - user-defined exceptions, Using EXCEPTION_INIT T... Using EXCEPTION_INIT To handle unnamed internal exceptions, you should use the OTHERS handler or the pragma EXCEPTION_INIT. The pragma is a compiler directive that can be th

Example of delete - sql, Example of DELETE - SQL As with UPDATE, a FOR... 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

Wrapping and unwrapping in sql, Wrapping and unwrapping in SQL Operato... Wrapping and unwrapping in SQL Operators WRAP and UNWRAP in connection with attributes whose declared types are tuple types. Example shows how extension and projection can be

Manipulating local collections - pl/sql, Manipulating Local Collections ... Manipulating Local Collections Within PL/SQL, to manipulate the local collection, by using the  TABLE and CAST operators . The operands of CAST are a collection declared locally

Example of using aggregation on nested tables, Example of Using Aggregation... 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

Nested tables versus index-by tables, Nested Tables versus Index-by Tables ... Nested Tables versus Index-by Tables The Index-by tables and nested tables are just similar. For e.g.  They have similar structure and their individual elements are accessed in

Dynamic sql - pl sql, Dynamic SQL: The Most PL/SQL programs do a predi... Dynamic SQL: The Most PL/SQL programs do a predictable, specific job. For illustration, a stored procedure may accept an employee number and salary increase, and then update t

Introduction to oracle, Introduction Oracle 9i - it was made publ... Introduction Oracle 9i - it was made public in the year 2001 with over 400 features, and graphics, it has merged the traditional business with modern internet application

Need database development with analysis tools, Need Database Development wi... Need Database Development with Analysis Tools Project Description: I want a database for large governmental and private data sets on one country that can be simply extended t