Keyword & parameter description - exceptions, PL-SQL Programming

Keyword & Parameter Description:


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.


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


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.


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
What Is a Record  ? A record is a group of related data items that stored in the fields, each with its own name and datatype. Assume that you have different data about an em

Parameter and Keyword Description: collection_name: This keyword identifies the index-by table, nested table, or varray formerly declared within the present scope. cu

Project Description: I want to write some SQL statements. The things I need are between pages 5-7. The only problem is that i want it till tomorrow. Skills required is SQL

Predicate - SQL Consider the declarative sentence-a proposition-that is used to introduce this topic:  "Student S1, named Anne, is enrolled on course C1." Recall that th

Using Cursor Attributes To process the SQL data manipulation statements, the SQL engine must opens an implicit cursor named SQL. This cursor's attributes (%FOUND, %NOTFOUND, %

Question: a) Given the following relation: Location(loc_id, bldg_code, room, capacity) The underlined field is a primary key. (i) Write a PL/SQL program using the impl

Running the PL/SQL Wrapper To run the PL/SQL Wrapper, go through the wrap command at your operating system prompt by using the syntax as shown: wrap iname=input_file [oname=

DBMS_OUTPUT: The Package DBMS_OUTPUT enables you to display output from the PL/SQL subprograms and blocks, that makes it easier to test and debug them. The procedure put_ line

Implicit Cursors The Oracle implicitly opens a cursor to process each SQL statement not related with an explicitly declared cursor. The PL/SQL lets you refer to the most recen

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