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
Benefit of the dynamic SQL: This part shows you how to take full benefit of the dynamic SQL and how to keep away from some of the common pitfalls. Passing the Names of Sc

Truth Tables: However in propositional logic - here we are restricted to expressing sentences and where the propositions are true or false - so we can check where a particular

Keyword and Parameter Description: label_name: This is an undeclared identifier which labels an executable statement or the PL/SQL block. You can use a GOTO statement to

a. Write an anonymous block that contains a PL/SQL function. Given an order number orderNo, the function will calculate the total number of the parts in the order. Then the anonym

Implicit Cursor Attributes The Implicit cursor attributes returns the information about the execution of an INSERT, DELETE, UPDATE, or SELECT INTO statement. The cursor attribu

V ariables and Constants in PL/SQL The PL/SQL permits you to declare constants and variables, and then use them in SQL and procedural statements anywhere in the expression. Th

Question 1 . Compare SQL and PL/SQL Question 2 . Write a database trigger to implement the following check condition                          Given the following table

Data Types in SQL - XML, Array, Row BINARY LARGE OBJECT for arbitrarily large bit strings. XML for XML documents and fragments. ARRAY types for arrays.

Assignment of Variable - Updating a Variable Syntax: SET SN = SID ('S2'); This can obviously be read as "set the variable SN to be equal in value to SID ( 'S2' )".

Overloading: Similar to packaged subprograms, methods of the same type can be overloaded. That is, you can use similar name for various methods if their formal parameters diff