Parameter and keyword description - exit statement, PL-SQL Programming

Parameter and Keyword Description:

EXIT:

An unconditional EXIT statement (i.e., one without a WHEN clause) exits the present loop instantly. The Execution resumes with the statement following the loop.

label_name:

This identifies the loop to be exit. You can exit not only the preent loop but any enclosing labeled loop.

boolean_expression:

This is an expression which yields the Boolean value TRUE, FALSE, or NULL. It is computed with each iteration of the loop in which the EXIT WHEN statement appear. If the expression yields TRUE, then the present loop (or the loop labeled by label_name) is exited instantly.

Posted Date: 10/8/2012 6:20:13 AM | Location : United States







Related Discussions:- Parameter and keyword description - exit statement, Assignment Help, Ask Question on Parameter and keyword description - exit statement, Get Answer, Expert's Help, Parameter and keyword description - exit statement Discussions

Write discussion on Parameter and keyword description - exit statement
Your posts are moderated
Related Questions
Overloading: Similar to packaged subprograms, methods of the same type can be overloaded. That is, you can use similar name for various methods if their formal parameters diff

Initializing Objects: Till you initialize an object by calling the constructor for its object type, the object is automatically null. That is, the object itself is null, not me

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

Cursor Variables:   To execute the multi-row query, the Oracle opens an unnamed work region that stores the processing information. You can use an explicit cursor that names

IN Mode An IN parameter pass the values to the subprogram being called. Within the subprogram, an IN parameter acts like a constant. And hence, it cannot be assigned a value.

Tables within a Table - SQL Figure here is an exact copy of the one in the theory book and as before it is just an alternative way of representing some of the information con

Defining and Declaring Records To create records, you have to define a RECORD type, and then declare records of that type. You may also define RECORD types in the declarative

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

Data Types in SQL - Character CHARACTER or, synonymously, CHAR, for character strings. When this type is to be the declared type of something (e.g., a column), the permissible

Table Literals - SQL One might expect SQL to support table literals in the manner illustrated in Example 2.2, but in fact that is not a legal SQL expression. Example: Not a