Answer / madhuri

Execution is exception is done in many ways.

An exception occurs when there is something wrong in the
code of pl/sql block.
Exception can be raised either in declarative,executable or
in exception section itself.
In case of nested blocks when an exception occurs in inner
block,it will try to find its handle in the same block,if
not then control comes out of inner block and executes the
handler in the outer block.

When exception occurs in declarative and exception
section,then control is propagated to the next outer block.

Answer / swapna

We use exceptions to check the status of our procs .. like
what to do if the things are not going smoothly as
expected . ie we insert errors in audit tables with
user,date-time,err code.

what is foreign key? : Sql dba

0 Answers  

---

What are the components of a PL/SQL block ?

3 Answers  

---

How to add, remove, modify users using sql?

0 Answers  

---

Is null operator in sql?

0 Answers  

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

0 Answers  

---

differentiate between float and double. : Sql dba

0 Answers  

---

What is sql prepared statement?

0 Answers  

---

how view used for security purposes?

3 Answers   Glam India,

---

What are the Restrictions on Cursor Variables?

2 Answers  

---

what are all different types of collation sensitivity? : Sql dba

0 Answers  

---

What is exit statement?

0 Answers  

---

Describe different types of general function used in sql?

0 Answers  

---