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
Data Types in SQL - Decimal DECIMAL, NUMERIC, REAL, FLOAT and various other terms for various sets of rational numbers. When these key words are specified for the declared typ

Case Sensitivity Similar to all the identifiers, the variables, the names of constants, and parameters are not case sensitive. For illustration, PL/SQL considers the following n

FOR-LOOP While the number of iterations through a WHILE loop is unknown till the loop completes, then the number of iterations through a FOR loop is known before the loop is ent

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

THEO R Y OF CATASTROPHISM OR CATALYSM (CUVIER 1769-1832) - The world has passed thorugh several stages and at the end of each stage there was a catastrophe killing all the

NULL Statement The NULL statement clearly specifies in action; it does nothing other than to pass control to the next statement. It can, though, improve the readability. In a

TYPES OF EVOLUTION - Sequential evolution                  :                    Minor changes in the gene pool of a population from one generation to the next, with the resul

Read-Only Operator (+) - SQL The term read-only operator to the mathematical term function. Here I just need to add that the SQL standard reserves the term function for read-

Using LIMIT For nested tables, that have no maximum size, the LIMIT returns NULL. For varrays, the LIMIT returns the maximum number of elements that a varray can have (that yo

LOB Types The large object (LOB) datatypes like BFILE, BLOB, CLOB, and NCLOB store the blocks of unstructured data (like graphic images, text, video clips, and sound waveforms)