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.

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.

Answer / rahul khanke

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

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.

Answer / avi007

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

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

difference between SQL and C

1 Answers   Indus Software Technologies,

How do you write an index?

0 Answers  

Are stored procedures faster than queries?

0 Answers  

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

0 Answers  

Where is sql database stored?

0 Answers  

Define the select into statement.

0 Answers  

Can a table have two primary keys?

44 Answers   HCL, MetaCube,

Is it mandatory for the primary key to be given a value when a new record is inserted?

0 Answers  

what is global variable in package

3 Answers   Polaris,

What sql database should I use?

0 Answers  

what is the difference between union and union all? : Sql dba

0 Answers  

What are character functions in sql?

0 Answers