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
Negation (NOT, ¬) - SQL There are three rows instead of just two. As you can see, ¬ p is defined as in two-valued logic (2VL) when p is either true or false, but ¬ (unknown) i

Implicit Rollbacks Before execute the INSERT, UPDATE, or DELETE statement, the Oracle marks an implicit savepoint . When the statement fails, the Oracle rolls back to the save

Use of Table Comparisons - SQL Table comparisons where it is noted that although table expressions cannot be compared, we have TABLE (t) to convert a table expression t into

Task 2 [12 marks] Write the package body for the following package specification (the detailed description of each function and procedure is provided in the appendix below). Place

Assignment Statement: The assignment statement sets the present value of the variable, parameter, field, or element. The statement consists of an assignment target followed by

Using SAVEPOINT The SAVEPOINT names and marks the present point in the processing of a transaction. Used with the ROLLBACK TO statement, the savepoints undo parts of a transac

to write a heap sort program usin pl-sql

Obtaining a natural join by specifying the common columns Synatax: SELECT * FROM IS_CALLED JOIN IS_ENROLLED_ON USING ( StudentId ) However, a named columns join doe

Example of ADD CONSTRAINT in SQL Example: Alternative formulation for MAX_ENROLMENTS ALTER TABLE IS_ENROLLED_ON ADD CONSTRAINT MAX_ENROLMENTS CHECK ((SELECT COUNT (*)

Use the RETURNING Clause Frequently, the application requires information about the row affected by a SQL operation, for illustration, to produce a report or take a subsequent