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 is sql in oracle?

0 Answers  

Enlist the characteristics of pl/sql?

0 Answers  

Can we insert data into materialized view?

0 Answers  

Can we join tables without foreign key?

0 Answers  

List different type of expressions with the example.

0 Answers  

what is the command for user data type?

2 Answers  

How do I remove sql developer from windows 10?

0 Answers  

If records are inserted into table without committing.How to refer to these values in a procedure?

2 Answers  

how many sql ddl commands are supported by 'mysql'? : Sql dba

0 Answers  

Write a query to find the names of users that begin with "um" in sql?

0 Answers  

How did you export data from database to excel file.

1 Answers   TCS,

How to get the procedure's, function's name from a package if it is wrapped(both spec & body).

2 Answers