Answer Posted / 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.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the use of triggers?
Is natural join same as inner join?
what are the types of subquery? : Sql dba
What is cartesian join in sql?
What is a natural join sql?
What is sql and explain its components?
How do I upgrade sql?
How do I audit the sql sent to the server?
What is sql resultset?
What is the order of sql select?
What is file based approach?
What is mdf ldf and ndf?
What is trigger types of trigger?
what is a trigger? : Sql dba
define sql update statement ? : Sql dba