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

Ask an Expert

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

Write your message here..

Related Questions

Data types in sql - decimal, Data Types in SQL - Decimal DECIMAL, NUME... 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-naming conventions, Case Sensitivity Similar to all the... 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 -iterative control, FOR-LOOP While the number of iterations thr... 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- 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

Theory of catastrophism or catalysm - origin of life, THEO R Y OF CATASTR... 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-sequential control, NULL Statement The NULL statement c... 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, TYPES OF EVOLUTION - Sequential evolution         ... 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, Read-Only Operator (+) - SQL The term r... 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 - collection method, Using LIMIT For nested tables, that h... 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 in pl/sql, LOB Types The large object (LOB) datatypes like BF... 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)