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

What are the built in functions of sql?

0 Answers  

When are we going to use truncate and delete?

0 Answers  

can i call procedure in package

3 Answers   TCS,

Where is sql database stored?

0 Answers  

How do you update a value in sql?

0 Answers  

What is sql catalog?

0 Answers  

What is the difference between RDBMS and DBMS?

20 Answers   Practical Viva Questions, Sapient, Stag Computers,

How do I use google cloud in sql?

0 Answers  

Explain dml and ddl?

0 Answers  

When should I use nosql database?

0 Answers  

What is a schema? How is it useful in sql servers?

0 Answers  

what is difference between procedure and function

10 Answers   MCN Solutions, Wipro,