Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


what is the order of pre-defined exceptions.

Answers were Sorted based on User's Feedback



what is the order of pre-defined exceptions...

Answer / roopesh kumar

We can directly handle them in exception section need not
to declare them. We need to declare them onle in case when
we want to put user friendly message instead of oracle's
default one.

Note: When others should be handle in last of exception
handling part of block.

Is This Answer Correct ?    3 Yes 0 No

what is the order of pre-defined exceptions...

Answer / rajadurai r

There are 20 pre-defined exceptions.

When an exception is raised,normal execution of your PL/SQL
block or subprograms stops and control transfers to its
exception-handling part.

Is This Answer Correct ?    2 Yes 0 No

what is the order of pre-defined exceptions...

Answer / rahul khanke

pre defined exception u should not have to declare in
declare section
ex. dul_value_error
when_duplicate_row
etc

Is This Answer Correct ?    1 Yes 1 No

what is the order of pre-defined exceptions...

Answer / chandra shekher

User Defined exceptions are executed prior to system
defined exceptions.

User defined exceptions are executed in the order in which
they are defined.

Is This Answer Correct ?    1 Yes 1 No

what is the order of pre-defined exceptions...

Answer / avi007

order of preddfined exceptions is to first catch the
exception in begin end; block

Is This Answer Correct ?    0 Yes 0 No

what is the order of pre-defined exceptions...

Answer / suresh somayajula

In these we will use 19+1 exceptions.

it means " When Others " is the last exception in

pl/sql block.execution will be end at When Others exception

Stmt.

suresh.

suresh.somayajula@gmail.com

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

8 Answers   L&T,


how to calcuate the second highest salary of he employee

13 Answers   Synechron,


What does varchar include?

0 Answers  


How does join work in sql?

0 Answers  


What is date functions?

0 Answers  


What are the cursor attributes used in PL/SQL ?

4 Answers  


Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

0 Answers  


Can a table contain multiple primary key’s?

0 Answers  


What is a join?Explain the different types of joins?

6 Answers   Bank Of India, CitiGroup, Google, ICICI, Saama Tech, SkyTech, TCS,


what are the differences among rownum, rank and dense_rank? : Sql dba

0 Answers  


Types of joins ?

3 Answers   Digital GlobalSoft, HeadStrong,


What is primary key secondary key alternate key candidate key?

0 Answers  


Categories