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

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

0 Answers  

how to get second highest salary in SQL(as/4000

29 Answers   iGate,

what is sql server agent? : Sql dba

0 Answers  

What is sqlcontext?

0 Answers  

What are the benefits of using PL/SQL packages?

3 Answers  

i want run a sql query query? which phases are run in a back ground? pls tell me the answer

1 Answers  

How much does sql cost?

0 Answers  

sql query to get zero records from a table having n no of records

8 Answers   CTS,

What is dml statement?

0 Answers  

What is sqlerrd?

0 Answers  

How many commands are in sql?

0 Answers  

Give an example of Full Outer Join?

1 Answers   IBM,