Keyword & parameter description - exceptions, PL-SQL Programming

Keyword & Parameter Description:

WHEN:

This keyword introduces the exception handler. You can have many exceptions execute the similar sequence of the statements by following the keyword WHEN with a list of the exceptions, unraveling them by the keyword OR. When any exception in the list is raised, the related statements are executed.

exception_name:

This identifies a predefined exception like ZERO_DIVIDE, or a user-defined exception formerly declared within the present scope.

OTHERS:

This keyword stands for all the exceptions not explicitly named in the exception-handling section of the block. The use of OTHERS is optional and is permitted only as the last exception handler. You cannot involve OTHERS in the list of exceptions subsequent the keyword WHEN.

Statement:

This is merely an executable statement. 

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







Related Discussions:- Keyword & parameter description - exceptions, Assignment Help, Ask Question on Keyword & parameter description - exceptions, Get Answer, Expert's Help, Keyword & parameter description - exceptions Discussions

Write discussion on Keyword & parameter description - exceptions
Your posts are moderated
Related Questions
UNION ALL - SQL Further varieties of UNION arise when we replace the key word DISTINCT by ALL in any of the foregoing examples, as in Example. ALL specifies that if row r appe

SELECT a.child_fname,a.child_lname,concat(b.parent_title,b.parent_fname), b.parent_lname,b.parent_tphone FROM child a,parent b WHERE a.parent_id=b.parent_id ORDER BY a.child_fnam

Records Records are the items of the type RECORD. The Records have exclusively named fields that can store the data values of various types. And hence, a record treat associate

Create a procedure named STATUS_SHIP_SP that allows a company to employee in the Shipping Department to update the status of an order to add shipping information. The BB_BASKETSTAT

Example of COALESCE operator Example: Give the total of marks for each exam (simplified solution) SELECT CourseId, COALESCE ((SELECT SUM (Mark) FROM EXAM_MARK AS EM

Question: (a) The objective of query optimization is to choose the most efficient strategy for implementing a given relational query, thereby improving the system performance. On

Using COUNT The COUNT returns the number of elements that a collection presently contains. For instance, when a varray projects contains 15 elements, then the following IF con

THEO R Y OF PANSPERMIA - Arrhenius (1908) postulated the cosmic panspermia theory that claims that organisms existed throughout the universe, and their spores, etc., could

#quesWrite a cursor to open an employee database and fetch the employee record whose age is greater than 45.tion..

Avoid the NOT NULL Constraint In the PL/SQL, using the NOT NULL constraint incur a performance cost. Consider the illustration as shown below: PROCEDURE calc_m IS m NUMB