Answer Posted / vaibhavi_dixit

When an exception is raised, oracle searches for the
handler in the PL/SQL block, if not then the exception is
propagated to the outer block.If the outer block handles
the exception, then the statments are commited (i.e 1 & 2),
the error message will be displayed and the control will
return to calling environment.
If the exception remains unhandled in all blocks ,then
before control returning to the calling environment,
statements i.e (1 & 2) will be rolled back.

VD

What are the types of join in sql?

1026

---

Explain exception handling in pl/sql?

987

---

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2226

---

Is sql a case sensitive language?

890

---

What is difference between procedure and trigger?

914

---

what are the 'mysql' command line arguments? : Sql dba

1084

---

How can you load multi line records? : aql loader

1017

---

What are the benefits of pl sql?

1049

---

Write a unique difference between a function and a stored procedure.

924

---

how many ways we can we find the current date using mysql? : Sql dba

1032

---

Can we use rowid as primary key?

941

---

What are the parameter modes supported by pl/sql?

1015

---

how to create a test table in your mysql server? : Sql dba

941

---

What is %rowtype in pl sql?

920

---

Why do we need pl sql?

934

---