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

Remote operations in pl sql, Remote Operations: As the illustration sh... Remote Operations: As the illustration shows below, the PL/SQL subprograms can execute the dynamic SQL statements which refer to the objects on a remote database: PROCEDURE

Referencing records, Referencing Records Unlike the elements in a coll... Referencing Records Unlike the elements in a collection, that are accessed using subscripts, the fields in a record are accessed by name. To reference an individual field, you

Example of shorthand for a row constraint - sql, Example of Shorthand for a... Example of Shorthand for a row constraint Example: Shorthand for a row constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Mark_in_range CHECK (Mark BETWEEN 0 AND 100);

I need sql - wp sql expert, I need SQL , WP SQL Expert Project Descripti... I need SQL , WP SQL Expert Project Description: Expert required to modify WP SQL query. Skills required are MySQL, SQL, PHP, Wordpress

Existential quantification - sql, Existential Quantification - SQL Ex... Existential Quantification - SQL Existential quantification-stating that something is true of at least one object under consideration-can be expressed by OR(r,c), meaning tha

Declaring cursor variables, Declaring Cursor Variables Once a REF CURS... Declaring Cursor Variables Once a REF CURSOR type is define by you, and then you can declare the cursor variables of that type in any PL/SQL block or subprogram. In the exampl

Organic evolution, Organi c Evolution Evolution is a slow continuou... Organi c Evolution Evolution is a slow continuous, irreversible and natural process of change to give rise to advance and diverse forms of life i.e. formation of new specie

Committing and rolling back - autonomous transaction, Committing and Rollin... Committing and Rolling Back The COMMIT and ROLLBACK end the active autonomous transaction but do not exit the autonomous routine. As the figure shows, if one transaction ends,

Parameter modes - pl sql, Parameter Modes: You do not require to speci... Parameter Modes: You do not require to specify a parameter mode for the input bind arguments (those used, for illustration, in the WHERE clause) as the mode defaults to IN. Th

Obtaining a natural join by specifying the common columns, Obtaining a natu... Obtaining a natural join by specifying the common columns Synatax: SELECT * FROM IS_CALLED JOIN IS_ENROLLED_ON USING ( StudentId ) However, a named columns join doe