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

Parameter and Keyword Description:


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.


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


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
Enrolment was split - SQL Example shows how relvars IS_CALLED and IS_ENROLLED_ON can be derived from the original ENROLMENT relvar, using projection in the initial assignment

How Exceptions Propagate ? Whenever an exception is raised, and if the PL/SQL cannot find a handler for it in the present subprogram or block, the exception propagates. That is

Components of an Object Type: An object type encapsulates the operations and data. Therefore, you can declare the methods and attributes in an object type specification, but no

heap sort program in pl/sql

Substitution and Instantiation - SQL It shows how NULL might appear in substitution for a parameter of a predicate and how it might thus participate in instantiation of that p

Parameter and Keyword Description: procedure_name The user-defined procedure is declared by this construct. parameter_name: This identifies the formal parameter t

DECLARE : This keyword signals the beginning of the declarative section of the PL/SQL block, that contains local declarations. The Items declared locally exist only within the

MILLER-UREY' S EXPERIMENTAL PROCEDURES - They recreated the probable conditions on the primitive earth in the laboratory. An atmosphere containing hydrogen, ammonia, me

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

%FOUND Subsequent to a cursor or cursor variable is opened but before the first fetch, the %FOUND yields NULL. Afterward, it yields TRUE when the last fetch returned a row, or