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

Explain Connect by Prior?

2 Answers  

Can we create a trigger on view?

0 Answers  

difference between table level constraint and column level and advantages of table level constraint

4 Answers   Doyensys,

What is sqlite used for?

0 Answers  

how can we destroy the session, how can we unset the variable of a session? : Sql dba

0 Answers  

How can I pass the inner procedure value to outer procedure ?

2 Answers  

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c

8 Answers   Oracle,

define sql insert statement ? : Sql dba

0 Answers  

How to run sql functions in pl/sql?

0 Answers  

What is duration in sql profiler trace?

0 Answers  

can i call procedure in package

3 Answers   TCS,

What do we need to check in database testing?

0 Answers