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
Methods: In normal, a method is a subprogram declared in an object type specification using the keyword MEMBER or STATIC. The method cannot have similar name as the object typ

Use the NOCOPY Compiler Hint By default, the OUT and IN OUT parameters are passed by the value i.e. the value of an IN OUT actual parameter is copied into the corresponding fo

Using Operator REF: You can retrieve refs by using the operator REF that, like VALUE, takes as its argument a correlation variable. In the illustration below, you retrieve one

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

Row Operators The Row operators return or reference the particular rows. ALL retains the duplicate rows in the result of a query or in an aggregate expression. The DISTINCT el

UNION without CORRESPONDING - SQL The use of UNION without CORRESPONDING. Example is merely by omitting CORRESPONDING, but only because the operands have identical SELECT clau

Use the MASCOT tables CREDITRS, PORDS and PAYMENTS to write SQL queries to solve the following business problems. These tables / data are available to you via the USQ Oracle server

Parameter and Keyword Description: package_name: This construct identifies the package. AUTHID Clause: This determine whether all the packaged subprograms impleme

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

Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l